Regarding Restore Database. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Regarding Restore Database.

Author

Topic

hspatil31
Posting Yak Master

182 Posts

Posted - 2009-02-05 : 02:20:03

Dear All,

I created one databse in SQL server 2005 like SS. I have one database backup file like SS.bak file. When i trying to restore database it gives following error. Can anybody suggest me how to solve followinf problem.

Error is,

Restore failed for server 'Harish', (Microsoft.SqlServer.Smo).

Additional Infomation:

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'SUDAL' database. (Microsoft.SqlServer.Smo)

Thanks and Regards
Harish Patil

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-02-05 : 04:22:48

try like this
while u keeping the .mdf,.ldf files while restoring check the condition over the existing database opiton (it will be on top in options) if u are restoring the .bak file in new database

hspatil31
Posting Yak Master

182 Posts

Posted - 2009-02-05 : 07:18:21

Dear Freind,

thnks for the reply. Solve problem.

Harish Patil

hspatil31
Posting Yak Master

182 Posts

Posted - 2009-02-05 : 07:19:57

Dear Freind,

thnks for the reply. Solve problem.

Harish Patil

jbp_j
Starting Member

24 Posts

Posted - 2009-02-05 : 07:58:03

hi bklr,

why we have to set the overwirte the Existing database for newly created databse.

i dont known what is the reson to set like that.

if u known please tell me.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources