Viewing 4 posts - 1 through 4 (of 4 total)
BACKUP and RESTORE operations don't block, but they are rather resource intensive, so it's quite possible that things might appear to be blocking to other users.
My first guess would be...
September 4, 2012 at 9:04 am
When you restore a database, the restored copy will be in the same recovery model as the source database was when backed up.
If you want the restored copy to be...
September 3, 2012 at 7:44 pm
To create backup filenames dynamically you'll want to generate the entire backup statement in a variable and execute it as dynamic sql. Something along the lines of this:
DECLARE @stmt NVARCHAR(255);
April 25, 2012 at 5:58 pm
Thanks so much for the tips. I ended up going with the guest user option and it's working great.
April 16, 2012 at 6:10 pm