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
Solved

Moving a database to a different partition

Posted on 1999-01-20
5
381 Views
Last Modified: 2008-03-04
I have 2 partitions on a Compaq Server: C: with 2 GB and D: with 7 GB. How to "move" all databases (the default-one's and one small user-db) from Partition C: to Partion D:? The whole SQL-Installation is in the default-path on C:. It's MS SQL Server V. 6.5 SP 3 and i look for a comfortable way to configure this server more cleverer, if possible without backup/restore!
0
Comment
Question by:nomadam
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:cjwik
ID: 1092733
It is possible, but not recommende to do this. If you look in the sp_device you will find wiche system table are storing the information about where the diveice are stored. If you change these values to your new ones, it should work.
0
 

Author Comment

by:nomadam
ID: 1092734
There is no stored procedure sp_device and maybe the question is misunderstood: I don't want to move the complete tree "mssql" with the Explorer as file-system from C: to D:! I am looking for a detailed (!) explanation how to manage this with the SQL Enterprise Manager (for example).
0
 
LVL 2

Expert Comment

by:cjwik
ID: 1092735
Well it would be impossible for me
0
 
LVL 7

Accepted Solution

by:
spiridonov earned 50 total points
ID: 1092736
Would this help you :
Sql Books Online: "Administrator's Companion" Part 5 Data Management --> Chapter 12 -->Basic Backup and Restore Operations -->About Load -->Moving  a Database.
If this is not what you need, reject the answer. I'll give you another one, which is more complicated (you will need to change system tables and Windows Registry)
0
 

Author Comment

by:nomadam
ID: 1092737
Thanks, now I should be able to never put "50 point questions" again.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

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