|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DB question
I currently run a server with an 80GB C: drive and a 300GB D: drive. I'd
like to move my DB from the 80 over to the 300 and repoint it. Is this possible? Any information would be greatly appreciated. Thanks. Bob Look up detaching and attaching databases in BOL
-- Show quoteHide quoteBB_DBA "Bob Mosley" wrote: > I currently run a server with an 80GB C: drive and a 300GB D: drive. I'd > like to move my DB from the 80 over to the 300 and repoint it. Is this > possible? Any information would be greatly appreciated. Thanks. Bob First a curiosity question :-), whats the size of your DB?
Go through the below link for moving your .mdf and .ldf file... http://support.microsoft.com/default.aspx?scid=kb;en-us;224071#XSLTH3157121122120121120120 -- Show quoteHide quoteThanks, Sree [Please specify the version of Sql Server as we can save one thread and time asking back if its 2000 or 2005] "Bob Mosley" wrote: > I currently run a server with an 80GB C: drive and a 300GB D: drive. I'd > like to move my DB from the 80 over to the 300 and repoint it. Is this > possible? Any information would be greatly appreciated. Thanks. Bob  
Other interesting topics
backup/restore vs attach/detach
Sql Server Resetting Ansi_Nulls Setting SysAdmin and ServerAdmin unable to start/stop or pause services How much allocated space is actually used? Change datatype var to nvar but log gets full Read only and access to specific databases Updating records in one table from another Retrieve DB path from a SP NEW B - {WildPacket} MSDARORA ?? |
|||||||||||||||||||||||
