additional drive (E:). I was thinking that there was a wizard in which we
could move our database from its location on the D: over to drive E:. We
would keep our log files on d:, and just move the database to the new E:
drive.
JohnThis is a multi-part message in MIME format.
--=_NextPart_000_016F_01C38D8E.0D24BDD0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Check out sp_attach_db and sp_detach_db in the BOL.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"John Navara" <jnavara@.nospam.com> wrote in message =news:#JyNb8ajDHA.1656@.tk2msftngp13.phx.gbl...
We are running out of space on our D: drive and are going to add an
additional drive (E:). I was thinking that there was a wizard in which =we
could move our database from its location on the D: over to drive E:. =We
would keep our log files on d:, and just move the database to the new E:
drive.
John
--=_NextPart_000_016F_01C38D8E.0D24BDD0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Check out sp_attach_db and =sp_detach_db in the BOL.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"John Navara"
--=_NextPart_000_016F_01C38D8E.0D24BDD0--
No comments:
Post a Comment