Wednesday, March 7, 2012

Moving physical Data file

In SQL SERVER 2000 i have 2(two) database at Drive D:\ & i want to move to
Drive E:\.
How i can move from ISQLW.sp_detach_db
Copy the files
sp_attach_db
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Jay" <sqldba@.abc.com> wrote in message news:618faa6f795a4065b6357fe01cb52d0b@.ureader.com...
> In SQL SERVER 2000 i have 2(two) database at Drive D:\ & i want to move to
> Drive E:\.
> How i can move from ISQLW.

No comments:

Post a Comment