|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
|
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
 |
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 I reinstall SQL 6.5. How can I restore the user databases? Answer: Read about DISK REINIT and DISK REFIT statements in SQL Server Books Online. If you have each user database on each own device and you need to restore SQL Server 6.5 databases, you can do the following: 1. Rename your old device (from Sales to Sales_old for example). 2. Create new device with the same name (Sales) and the same size as your old device. 3. Create new database on this device with the same name and the same size as your old database. 4. Stop MSSQLServer service. 5. Drop new device and rename old device (Sales_old) with its old name (Sales). 6. Start MSSQLServer service. |