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)
 Moving a SQL Database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-01-20 : 08:18:03
Scott writes "I would like to move my SQL server database from 1 drive to another on the same server, what would be the 'best' method to do this?

Thank you,

Scott"

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-01-20 : 08:27:22
attach ... move files ... detach
detach ... move files ... attach <rolleyes>


Jay White
{0}

Edited by - Page47 on 01/20/2003 08:27:47
Go to Top of Page

zipman1952
Starting Member

14 Posts

Posted - 2003-01-20 : 10:55:41
page47, I cannot find 'rolleyes' in BOL - is is an extended proc perhaps?

Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-01-20 : 11:02:55
Exaaaaaactly ...

Jay White
{0}
Go to Top of Page

Arnold Fribble
Yak-finder General

1961 Posts

Posted - 2003-01-20 : 11:22:28
I think he meant <rolleyes/>
but that's what XML does to you after a while.



Go to Top of Page

zipman1952
Starting Member

14 Posts

Posted - 2003-01-23 : 11:17:29
roll them jaundiced eyes...


Go to Top of Page
   

- Advertisement -