Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
morlock21
Starting Member
6 Posts |
 Posted - 2007-03-06 : 00:39:35
|
| friend can i ask something like thiswhat query that can i truncate the transaction logs or shrink it into 2mb.Please response to this. I need helpThanks |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-06 : 00:41:44
|
| See http://support.microsoft.com/kb/256650 |
 |
|
|
morlock21
Starting Member
6 Posts |
Posted - 2007-03-06 : 00:46:15
|
| sir thanks, i need help about to truncate logs in mssql 7.0 what command can i used |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-06 : 00:48:59
|
| What's wrong with all the commands that are in the article in the link? |
|
|
|
morlock21
Starting Member
6 Posts |
Posted - 2007-03-06 : 00:58:41
|
| yes sir, how to transfer into command batch files? please help me thanks |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-06 : 01:10:17
|
| BACKUP LOG in Books Online |
|
|
|
morlock21
Starting Member
6 Posts |
Posted - 2007-03-06 : 01:13:48
|
| sir what do mean by this? BACKUP LOG in Books Online, thanks... i need it to transfer into command batch files auto generated. thanks again |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-06 : 10:42:16
|
| I mean the command you are looking for is BACKUP LOG and you can find all the information about it in Books Online. |
|
|
|
|
|
|
How to truncate transaction logs in sql server 7.0