Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Tired on doing those transactional backups
Message
 
 
À
29/03/2011 19:38:16
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Scripting
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01505423
Message ID:
01505427
Vues:
46
>All day long, I had to do several transactional backups because my scripts were being blocked otherwise. So, I had to go in the database right click Properties, select Task/Backup, switch the backup type to Transaction log and do the backup. Then, I was able to execute my script. Then, I run the script. It runs ok. Then, I try to run a similar one. I get the same thing. So, this is turning into a loop here. What is causing this?

Can you get the script of your action (press the script button in that dialog).

Then at least you'll be able to use the script and not repeat the same process.

As to why you're getting the error, the blog post I gave a reference to in my prior message, provides an explanation.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform