SQL DB Move

[sidradical]

Hello all,

I have a SQL server setup with a D: and E: partition with the Data on one and the logs on the other. Recently one of my colleagues installed a new DB but installed both logs and data on the D partition. For continuity I would like to move the data onto the E: and would be grateful for some assistance in the best way of doing this.

The server is SQL 2000 however I would also like to know how this is done in SQL 2005 should I ever come across the scenario again.

Thanks in advance.

 

[JayKusch]

in Enterprise Manager, drill down on the database and choose detach.

Once detached, move the physical file to its needed share.

Once in place, r-click on the database tree label in EM and choose attach.

Point the location of the TLog (which should be showing as missing) to the new location.


Thanks

J. Kusch

 

[sidradical]

Thanks, this is actually very straight forward now that I know the steps.