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@.ur
eader.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.
Showing posts with label todrive. Show all posts
Showing posts with label todrive. Show all posts
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.
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.
Subscribe to:
Posts (Atom)