DataField
asked on
move master database datafiles in SQL Server 2000
Experts,
It is SQL Server 2000.
I try to test how to move master database datafiles to a different folder, and I did the following step:
1. change the path from 'SQL Server Properties-->Startup Parameters'.
2. stop SQL Server and copy the master database datafiles to the new directory.
But I can't restart the SQL Server anymore, just wonder what I did wrong?
How to fix the issue?
Thanks a lot!
It is SQL Server 2000.
I try to test how to move master database datafiles to a different folder, and I did the following step:
1. change the path from 'SQL Server Properties-->Startup Parameters'.
2. stop SQL Server and copy the master database datafiles to the new directory.
But I can't restart the SQL Server anymore, just wonder what I did wrong?
How to fix the issue?
Thanks a lot!
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Glad to be of assistance. May all you days get brightere and brighter.
ASKER