Solved

How to properly move a sql database?

Posted on 2008-06-18
8
191 Views
Last Modified: 2012-08-13
I need to move a sql database to a new hard drive with more space for the db to grow. In SQL 2000 how can I do this?
0
Comment
Question by:MicroAutomation
  • 5
  • 3
8 Comments
 
LVL 60

Expert Comment

by:chapmandew
ID: 21813620
Take a backup of your database (full backup) along with running DBCC CHECKDB on the database.  AFterwards, detach your database and copy the files over to the other server.  Once you've copied them there attach them.  
0
 

Author Comment

by:MicroAutomation
ID: 21815040
WIll any currently setup sql jobs or replication be affected? In other words will I have to tweak all the scheduled jobs and such?
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 21815047
IF it is on the same server then you won't need to change any of that stuff, no.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

Author Comment

by:MicroAutomation
ID: 21815077
sweet thanks...i will give a try..
0
 

Author Comment

by:MicroAutomation
ID: 21821852
when trying to detach the database in order to copy the system shows:

attention: the database cannot be detached while it is being replicated
0
 

Author Comment

by:MicroAutomation
ID: 21821941
ok i got the disabling publushing wizard now and when trying to do this it says it could not diable publishing and distribtuion on <server name>

Error 2812: Could not find stored procedure 'master...xp_commandshell'
0
 

Author Comment

by:MicroAutomation
ID: 21822296
i was able to take the database offline and am now coppying it over
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 125 total points
ID: 21823094
Cool...I didn't realize that you were using replication or I'd have mentioned that.  Sorry about that.  
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question