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 - 2005-06-03 : 07:43:51
|
| Teymur writes "Dear All.I have SQL 6.5 Server, Windows NT.There are devices as below--Devices|__Dev1 (C:\dev1.dat - 50 M)|__Dev2 (C:\dev2.dat - 50 M)|__Dev3 (C:\dev3.dat - 49 M)--Databases|__DB1 ->Dev1 - 10 M|__DB2 ->Dev2 - 40 M|__DB3 ->Dev3 - 30 M!!! Both data and log file are in the same device.1.1.1 Stop MS SQL Server1.2 Rename c:\dev2.dat to c:\@dev2.dat1.3 Rename c:\dev1.dat to c:\dev2.dat1.4 Start MS SQL ServerResult: DB2 is not in suspect mode, working properly.2.2.1 Stop MS SQL Server2.2 Rename c:\dev1.dat to c:\@dev1.dat2.3 Rename c:\dev2.dat to c:\dev1.dat2.4 Start MS SQL ServerResult: DB1 is not in suspect mode, working properly.3.3.1 Stop MS SQL Server3.2 Rename c:\dev3.dat to c:\@dev3.dat3.3 Rename c:\dev2.dat (or c:\dev1.dat) to c:\dev3.dat3.4 Start MS SQL ServerResult: DB3 is in suspect mode, cannot be opened.Does it mean that this problem due to size difference between Devices? Is there any option to complete the last task?Thanks in advance." |
|
|
|
|
|
Exchange data files between database in SQL 6.5