Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Backup Shrink Logs
Message
From
28/01/2013 18:57:21
 
 
To
28/01/2013 18:52:26
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01564409
Message ID:
01564422
Views:
40
>So to go through 50 databases I would do something like this:
>
>
>Alter Database MyDatabase Set Recovery Simple
>Use MyDatabase
>DBCC ShrinkFile (MyDatabase_Log,1)
>Alter Database MyDatabase Set Recovery ?? -- set back to the original setting?
>
>Alter Database MyDatabase_2 Set Recovery Simple
>Use MyDatabase_2
>DBCC ShrinkFile (MyDatabase_2_Log,1)
>Alter Database MyDatabase Set Recovery ??
>
>
>Do I need to put "go" between the lines?

Well, if you set it like that, you will not benefit from the full log, in case you would need it. In my case, I never keep it. At midnight, before the backup, it does that automatically. So, I only copy the data. But, if you really do not need the full log, yes, that could be an approach to use. There might be something simpler directly at the backup command line however. But, that would work for sure. As for the go, I do not think it is necessary here. But, you can try. If it doesn't execute, then you can insert it.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform