June 2, 2005 at 11:38 pm
Dear All.
Below is my configuration of SQL 6.5 Databases.
-Database Devices
|__Dev1 (C:\dev1.dat Size = 50 M)
|__Dev2 (C:\dev2.dat Size = 50 M)
|__Dev3 (C:\dev3.dat Size = 40 M)
-Databases
|__DB1 ->Dev1 Size = 10M
|__DB2 ->Dev2 Size = 10M
|__DB3 ->Dev2 Size = 10M
1.Between DB1 and DB2
1.1 Stop SQL Server.
1.2 Rename C:\dev2.dat to C:\@dev2.dat
1.3 Copy and Rename C:\dev1.dat to C:\dev2.dat
1.4 Start SQL Server.
1.5 DB1 and DB2 is working properly, not in suspect mode
2.Between DB2 and DB1
2.1 Stop SQL Server.
2.2 Rename C:\dev1.dat to C:\@dev1.dat
2.3 Copy and Rename C:\dev2.dat to C:\dev1.dat
2.4 Start SQL Server.
2.5 DB2 and DB1 is working properly, not in suspect mode
1.Between DB3 and (DB1 or DB2)
1.1 Stop SQL Server.
1.2 Rename C:\dev3.dat to C:\@dev3.dat
1.3 Copy and Rename C:\dev1.dat to C:\dev3.dat
1.4 Start SQL Server.
1.5 DB3 is not working properly, in suspect mode.
But if the size of Dev3 was as Dev1, DB3 would not be in suspect mode.
In short, I want to Create new database and replace it's datafiles with existing one.
I hope the EXPERT GUYS WILL BE HELP ME...
Thanks in advance.
Best regards
June 3, 2005 at 9:05 am
If you create a new db in v6.5, it has to be the same size and structure in terms of device files. If you want the new db to be smaller or larger, you'd need to BCP out all data, script out the objects, create the new db, create the objects (tables, views, stored procs), then bcp in.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply