October 1, 2009 at 7:13 pm
When a restore is done from a backup from another server, onto an existing database in another SQL Server, (database name on both servers are the same); does it overwrite 100% of everything(SP, keys, Constraints, Statistics etc) over the existing database? Is there anything else we need to carry from 1st server to 2nd server for this database?
I guess when it is restored as a new Database (not overwriting over an existing one), then it will be straight-forward and will carry over everything from the original source database.
Thanks
Dan.
October 1, 2009 at 10:08 pm
The database backup includes everything from the original database.
What you don't get is things such as logins which are server level items and, typically, these are in the master database.
October 2, 2009 at 4:00 am
Thanks happycat59
October 2, 2009 at 9:23 am
You need also to script and transfer all database related jobs, SSIS packages, operators, and alerts.
All of this things are server level objects and will not transfer with database backup/restore.
October 2, 2009 at 11:58 am
Sergey, Got it! thx.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply