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 |
|
ser_ora
Starting Member
3 Posts |
 Posted - 2008-10-02 : 14:58:17
|
| Hi,I'm working with one SQL Server 2005 and need to move the master files to another location. Can you help me on this issue?I know that for master I can't use the "alter database master modify file....) like for user database.Thanks,Ser |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2008-10-02 : 15:06:53
|
| http://support.microsoft.com/kb/224071Thanks ! |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-02 : 15:07:13
|
| Any reason to move master DB? See this:http://msdn.microsoft.com/en-us/library/ms345408.aspx |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-02 : 21:37:57
|
| beware- you need to keep master and mssqlsystemresource data files in same folder for sql server 2005 to run properly, this requirement has changed in sql 2008 where mssqlsystemresouce datafiles are placed in binn folder. |
|
|
|
ser_ora
Starting Member
3 Posts |
Posted - 2008-10-03 : 07:41:27
|
quote:
Originally posted by sqldba20
http://support.microsoft.com/kb/224071Thanks !
Thanks  |
|
|
|
ser_ora
Starting Member
3 Posts |
Posted - 2008-10-03 : 07:46:25
|
quote:
Originally posted by saurabhsrivastava
beware- you need to keep master and mssqlsystemresource data files in same folder for sql server 2005 to run properly, this requirement has changed in sql 2008 where mssqlsystemresouce datafiles are placed in binn folder.
ok.....I'll check this issue. Tks... |
|
|
|
|
|
|
SQL Server 2005 and moving master datafile