August 19, 2008 at 9:10 am
Hi
i need to do following steps to complete my schedule job or Proccess in MSSQL 2000
Before steps i give brief description of proccess
i get a backup file from vendore (Standerd backup) with following format
xxxyymmddsss.Bak
1.need to pick up right backup file may be with wildcard.
2.verify backup set
3.backup users before restore happen
4.kill users before restore take place
5.Restore database
6.Bring database online]
7.Restore users and roles back to restored database
and you can also suggest if i miss any part of process.
thanks in advance.
August 19, 2008 at 11:58 am
The step 7, restore users and roles. You need to backup the users and roles before restoring your database, normally.
August 19, 2008 at 12:27 pm
I am a bit picky so, I would possibly do this a bit different in that I would restore the new database as a different name than the original until I was sure that everything was correct (permissions, data, etc) so that in the event that I had a bad backup received from the customer I wouldn't have to bring the previous database back online as it would already be there. Does this make sense in the way that I explained it? This may not be a requirement that you have but I don't like the idea of a headache of "rolling back" to the previous version. My guess is that it will happen at some point in the future.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply