Restore SQL database (MSDE)

Hi!
We had to resoft our PC, but before we formatted the whole PC, we made a
backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
get the error message "The backup set holds a database other than the
existing 'our dbname' database". Both the old and the new db was created
with MSAccess, and when we try to restore with Access (adp), we get a
similar error msg.
Any ideas?
TIA
Ulf H.Read about the RESTORE command in Books Online, and especially the MOVE and REPLACE parameters.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ulf Hansen" <someone@.somewhere.com> wrote in message news:j1OWc.2838$g%5.36571@.news2.e.nsc.no...
> Hi!
> We had to resoft our PC, but before we formatted the whole PC, we made a
> backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
> etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
> restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
> get the error message "The backup set holds a database other than the
> existing 'our dbname' database". Both the old and the new db was created
> with MSAccess, and when we try to restore with Access (adp), we get a
> similar error msg.
> Any ideas?
> TIA
> Ulf H.
>|||Hi Ulf,
Thanks for using MSDN Managed Newsgroup!
Thanks MVP Tibor's greatest answer! How are things going on yours? Have you
use RESTORE successfully? I would appreciate it if you could post here to
let me know the status of the issue. If you have any questions or concerns,
please don't hesitate to let me know. I look forward to hearing from you,
and I am happy to be of assistance.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Restore SQL database (MSDE)

Hi!
We had to resoft our PC, but before we formatted the whole PC, we made a
backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
get the error message "The backup set holds a database other than the
existing 'our dbname' database". Both the old and the new db was created
with MSAccess, and when we try to restore with Access (adp), we get a
similar error msg.
Any ideas?
TIA
Ulf H.Read about the RESTORE command in Books Online, and especially the MOVE and
REPLACE parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ulf Hansen" <someone@.somewhere.com> wrote in message news:j1OWc.2838$g%5.36571@.news2.e.nsc.
no...
> Hi!
> We had to resoft our PC, but before we formatted the whole PC, we made a
> backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
> etc.). Now, after we have installed MSDE on the "clean" PC, we're trying t
o
> restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
> get the error message "The backup set holds a database other than the
> existing 'our dbname' database". Both the old and the new db was created
> with MSAccess, and when we try to restore with Access (adp), we get a
> similar error msg.
> Any ideas?
> TIA
> Ulf H.
>|||Hi Ulf,
Thanks for using MSDN Managed Newsgroup!
Thanks MVP Tibor's greatest answer! How are things going on yours? Have you
use RESTORE successfully? I would appreciate it if you could post here to
let me know the status of the issue. If you have any questions or concerns,
please don't hesitate to let me know. I look forward to hearing from you,
and I am happy to be of assistance.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Restore SQL database (MSDE)

Hi!
We had to resoft our PC, but before we formatted the whole PC, we made a
backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
get the error message "The backup set holds a database other than the
existing 'our dbname' database". Both the old and the new db was created
with MSAccess, and when we try to restore with Access (adp), we get a
similar error msg.
Any ideas?
TIA
Ulf H.
Read about the RESTORE command in Books Online, and especially the MOVE and REPLACE parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ulf Hansen" <someone@.somewhere.com> wrote in message news:j1OWc.2838$g%5.36571@.news2.e.nsc.no...
> Hi!
> We had to resoft our PC, but before we formatted the whole PC, we made a
> backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
> etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
> restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
> get the error message "The backup set holds a database other than the
> existing 'our dbname' database". Both the old and the new db was created
> with MSAccess, and when we try to restore with Access (adp), we get a
> similar error msg.
> Any ideas?
> TIA
> Ulf H.
>
|||Hi Ulf,
Thanks for using MSDN Managed Newsgroup!
Thanks MVP Tibor's greatest answer! How are things going on yours? Have you
use RESTORE successfully? I would appreciate it if you could post here to
let me know the status of the issue. If you have any questions or concerns,
please don't hesitate to let me know. I look forward to hearing from you,
and I am happy to be of assistance.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!