When we try to restore the database in the existing one , SQL SERVER 2008 will throw an Error as shown as below.
The reason for this Microsoft Designed to ensure the data could recover up to the maximum extent
and losses may not be even happen.
While we try to restore with replace command as follows.
Warning: Be careful we are trying to delete the existing database and replace with some other data's.
The reason for this Microsoft Designed to ensure the data could recover up to the maximum extent
and losses may not be even happen.
While we try to restore with replace command as follows.
RESTORE DATABASE [AdventureWorks]
FROM DISK = N'C:\backup\adventureworks'
WITH FILE = 1, replace, STATS = 10
GO
Warning: Be careful we are trying to delete the existing database and replace with some other data's.
No comments:
Post a Comment