Home > Archive > MS SQL Server > March 2006 > DB question









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author DB question
Bob Mosley

2006-03-14, 1:23 pm

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
Bryan

2006-03-14, 1:23 pm

Look up detaching and attaching databases in BOL
--
BB_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
Sreejith G

2006-03-16, 7:23 am

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/defaul...122120121120120

--
Thanks,
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
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com