Solved

Moving a database to a different partition

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 2012 r2 - Sum totals 2 23
hyperlink data type in SQL 3 26
Sql server function help 15 28
always on switch back after failover 2 32
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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.

776 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