Solved

Moving a database to a different partition

Posted on 1999-01-20
5
391 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
[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
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

739 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