Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backup Shrink Logs
Message
De
28/01/2013 18:57:21
 
 
À
28/01/2013 18:52:26
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01564409
Message ID:
01564422
Vues:
39
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform