November 20, 2004 at 9:23 pm
Hi,
I did full scan backup for a database and the backup file is stored in the remote server.
After one hour i send that backup file from the remote server to the experiment server.
But i am not able to restore that database in the experiment server ( i created the database in the experiment server with the same name of the backup database).
the error is
----------
database inconsistancy error and pls take a support from technical adviser.
pls help me what should i do
November 22, 2004 at 2:20 pm
Try dropping the database you created on the experiment server and let RESTORE create the database. See 'How to restore a database with a new name' in BOL.
Greg
Greg
November 22, 2004 at 2:24 pm
thanks for sending the reply.
i will try for it , and if i get the any problems , i will contact you
thank and best regards
sripal
November 24, 2004 at 7:32 am
The problem is that you are trying to RESTORE a database that already exists. It can be done, but you must use the WITH REPLACE option.
Refer to the BOL for more information.
-SQLBill
BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply