Solved

Moving a database to a different partition

Posted on 1999-01-20
5
365 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

919 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now