November 12, 2010 at 12:23 pm
I am confused as to if i restore a backup of a database to other existing database, then will the tables, stored procs, functions, all will be changed according to the restored database or it will be same as it was earlier ( exisitng database)
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
November 12, 2010 at 12:37 pm
the new database (after restoration) will contain everything that your full backup had. nothing more nothing less.
November 12, 2010 at 12:43 pm
let me be more clear :-
If i have database1 and database2 .
I take a full backup of database1 and then restore it on database2,
then the database2 will have all the objects same as in database1 ( at time of backup) or the objects will be same as it was earlier on database2 before restoration.
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
November 12, 2010 at 12:57 pm
If you take a backup of database1 and restore it over database2, you are completely replacing database2 with database1. It's the equivalent of dropping (deleting) database2 completely, then restoring database1 with a different name.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2010 at 12:59 pm
SKYBVI (11/12/2010)
I take a full backup of database1 and then restore it on database2,then the database2 will have all the objects same as in database1 ( at time of backup) or the objects will be same as it was earlier on database2 before restoration.
that's what i answered earlier.
the new database (database2), after restoration from backup of database1, will look exactly same as database1 (the way database looked when backup completed).
November 12, 2010 at 1:05 pm
thxs a lot
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply