Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tired on doing those transactional backups
Message
 
 
To
29/03/2011 19:38:16
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01505423
Message ID:
01505427
Views:
45
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform