Windows Forum

Ask something
Discussion Locked

Moving SQL 7 to another partition

0 helpful
5 replies

by bobby gillette

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We are running SQL 7.0 on Windows NT, and we are needing to move the installation from one partition to another with more disk space. Is there a simple way to do this (ie Registry changes etc,) or does any one know which TechNet article explains it?

TIA,
Bobby

5 replies

by shmaltz

I know there is a lot of problems involved doing this. What I once did was to assign to the new partition the old drive letter. That way SQL had no idea the harddrive has been moved.

by kza_iran

hi,
if you refer to the ms-sql books online, you will find three way to do your job:
1- using attach and detach ms-sql commands
2- backingup and restoring
3- copying databases

you need to do your job one database at a time, that may seem very tedious, but i think it is the only way. if there is more question send message to kza_iran@hotmail.com, i hope i can help you,
sincerly yours,
k.zonouzi ahmad

This discussion is closed to new replies.