Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to properly move a sql database?

Posted on 2008-06-18
8
Medium Priority
?
196 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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 375 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
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.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

718 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