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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backups/restores

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-17 : 21:25:08
Sira writes "Sometimes when you try to restore over an exisiting database it gives an error so I believe changing the .mdf to .bak works.....Why does that work or rather what is happening?"

chadmat
The Chadinator

1974 Posts

Posted - 2002-04-18 : 02:30:53
What is the error?

Just a shot in the dark, Are you using 'WITH REPLACE'?

-Chad

Go to Top of Page

sandesh_moghe
Constraint Violating Yak Guru

310 Posts

Posted - 2002-04-18 : 04:55:51
Force the new Bak up file to the existing database.

---------------------------
Sandesh - The Messanger
Go to Top of Page
   

- Advertisement -