Yes I am backing up the database daily. I am taking the backup of complete database not just a ldf or MDF file. But I don't know how to truncate the log to remove old,unneeded transactions. How this can be done? Thanks
User 2071301
Posts
-
increasing size of LDF file -
increasing size of LDF fileHi All, In my project database is SQL server. The LDF file size is increasing considerably(now it is 16 gb). It may be due to unCommited transactions. My question is that if I close the connection after each query execution will it commit the transaction so that the file size will be small.? or is there any other solution to decrease the file size? Thanks
-
SQL SERVER log file increasing remarkablyHi All, I am using SQL server 2000, one of my data base log file size has reached to the size of 30 gb. Even after transactional back up size did not decrease. Then I delete the log file and recreated it, still it is growing remarkably. My datbase setting for Recovery Intreval is 0(zero) minutes. Can anybody tell me why this file is increasing so fast? Thanks for the help.
-
Creating .Net siteDear All, I am having a site which is in asp (not aspx) and now I want to upload some more pages which are having .aspx; these pages are not the part of the site but creates a different site.
-
About IndexingI have created an index for the folder(windows2000 operating sys). Now I want the script of Indexing. Where can I get the script? Thanks, Anant
-
Calling javascript in ASP.NETHi there, I am calling a javascript on a server control in ASP repeater. but as i click the button in asp repeater it generates the error as 'Control' is undefined. the reason of the error may be as there is different identification for each control in the repeater. can anybody tell me how to recover the error?
-
About a java script errorHi there, I am using a java script calender in an asp.net application. As i run the application an error msg as 'Microsoft JScript runtime error: 'Txt_box' is undefined' where 'Txt_box' is a server side text box control. can anybody help me to sort out the problem?
-
About audio streamingHi there, I want to record some sound. The audio file would be .wma,.mp3. Can anybody tell me how i can achieve this in asp.net? Thanks for the help.
-
adding child to parent node in a treeview.Hi all, i m using a treeview control. i m successful in adding nodes at run time, but my problem is tht i wanted to add nested treenodes. that means root node child one of root node child one of child one child two of child one ----- ------- child 'n' of child one child two of root node child one of child two child two of child two ----- ------- child 'n' of child two ----- ------- child 'n' of root node can anybody help me i 've added treenode as child one but now i want to add child of child one at run time.
-
DataGridIt may be due to reason that your page index get changed after delision. after delision set current page index as 1
-
Regarding ChecklistBoxHi, u try for div tag. it works.
-
Displaying .tif images in web browser using asp.nethi all, i want to display the .tif(tagged image file format) file in the web browser. can anybody help me? thanx.