Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL 7 database move question

Author  Topic 

wolfgang2010
Starting Member

6 Posts

Posted - 2010-01-04 : 09:38:16
I'm running out of hard drive space on one of our servers. I would like to add a 2nd hard drive and move my database there.

My question is this I can detach, move files, attach just fine but I have replication setup on the datbase and would rather not go thru setting that up again. Any way to keep it? We've always had to do the painful steps of recreating it and scheduling in the past. I would think there should be an more easy way?

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2010-01-05 : 12:23:14
It may be easier to upgrade the hard drive the data is already on. I like Norton ghost (dos mode) in times like these.
Go to Top of Page

wolfgang2010
Starting Member

6 Posts

Posted - 2010-01-05 : 12:55:39
I've tried this in the past and it worked but then sometime later I get a blue screen and end up reloading EVERYTHING :) But perhaps I was using the wrong software.
Go to Top of Page
   

- Advertisement -