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 |
|
PaulTeal
Yak Posting Veteran
67 Posts |
 Posted - 2002-12-05 : 16:33:05
|
| I need to change the drive location for the .mdf file for one of my databases. BOL does not seem to address simply moving these files. Will I need to create a 2nd file in the filegroup, then delete the 1st? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-05 : 16:56:32
|
| Using sp_detach_db and sp_attach_single_file_db is probably the easiest way to move the file. See Books Online for more details. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-12-05 : 17:02:44
|
| INF: Moving SQL Server Databases to a New Location with Detach/Attach [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071[/url]HTHJasper Smith |
|
|
|
PaulTeal
Yak Posting Veteran
67 Posts |
Posted - 2002-12-05 : 21:22:28
|
| I would have looked for that all day. Honestly, thank you very much.Paul Tealsql@partytilyoupop.com |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-05 : 21:24:58
|
| http://www.partytilyoupop.comInteresting combination of jobs. |
|
|
|
PaulTeal
Yak Posting Veteran
67 Posts |
Posted - 2002-12-05 : 21:59:57
|
| Yes, I am a SQL Programmer by day, children's entertainer by night.Paul Tealsql@partytilyoupop.com |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-12-05 : 22:07:15
|
Wow, at my former company, during presentations to upper management, I did BOTH of those!  You'd be amazed how often CFO's cough up the funds when you give them a balloon dog! |
|
|
|
|
|
|
Change Location Of .mdf