My guess is that DTS is grabbing a connection before attempting to execute the script.  I've found that generally when I get all users out of a database for an offline...

Obviously, if your data is of any importance at all, some sort of external storage is a must.  What you use for that storage is a matter of what is...

Now, the suggestion becomes -

Please don't post multiple instances of the same request.  Makes it hard to follow the thread. 

Personally, even without knowing more about the situation, I would suggest changing operating systems.  Windows ME is not known for being stable.  Try Windows 2000 or XP.

Steve

Its not difficult to do this with a stored proc.  You'll need to build the backup command within the proc with the "TO DISK =" clause.  You'll build the filename...

No.  If the tlog backup runs at the same time the db backup runs, whichever one starts first will BLOCK (not lock) the other until it finishes.  Nothing at all...

This is kind of a tough question, because the answer is - "It depends."

But the first thing that I would suggest is forget about shrinking (removing unused space from the...

Hey Aaronsandy,

Out of curiosity, are you attempting to learn SQL at home, or are you attempting to support your company?  The reason I ask is because I have seen so...

4200 or 42000?  I could find no references to 4200/3202, but several for 42000/3202 by searching on http://www.google.com .  Having found that, I re-searched Books Online.  42000 is for...

Backups will not lock any data.  After the backup has "completed", it goes back to the transaction log and picks up any changes that occured during the backup.

Steve

The main thing that you will see with the transaction log backup and full backup running concurrently is that one or the other will be blocked until the other is...

I assume that you have a scheduled job that is issuing the dir command through xp_cmdshell.  Once you have confirmed that you have your files, you can run your dts...

Restore your database from the full backup using the NO RECOVERY clause.  Then restore EACH transaction log backup since the full backup up to the time in question (11:00am), also...

OK, I understand.  I have seen this in other Windows applications (not just Microsoft).  All windows basically take on the characteristics of whatever change you make.  I don't encounter it...

>>

 For Log Backup the same file is used again and again. Transaction log back up overwrites the Logbackup file and the full backup deletes it and creates a new...