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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-09 : 08:38:25
|
| Jims writes "SQL Team we are using ur Product SQL server 7.0 and due to some installations our database server is deleted from the disk.but we have back up of our database so i want ot reinstall SQL server 2000 and backup our database.plz send me the informations how i can restore my database using SQL server 2000 in place of Sql server 7.oi will pay great thanks to u if u provide me an urgent help.it will help us in lessing the loss of our company.JimsNazarshahgroup of IndustriesLahorePakistan" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-06-09 : 11:49:25
|
| Do you mean you have backups or have you just lost the servers but have mdf files.If the former then just install v2000 and erstore the backups - they should be upgraded for you.If the latter then install v7 try an sp_attch_db, backup the databases, install v2000 restore the backups (or just upgrade the server to 2000).If the mdf's don't attach then you can still get most of the data but it's a bit more complicated.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Restoring backup