Moving the location of an MSDE database?

My friend has installed a copy of SBS Standard and is using SharedPortal Server which is using MSDE to store its data. As he expects the database to grow, he wishes to move the files off the C-drive (the default location) to a larger data drive.
How do you go about backing up and moving MSDE database's to a new location?
Any help would be much appreciated.
Thank you in advance.
Simon
hi Simon,
"Simon M" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:CD922A26-B656-4AD1-928F-FD18D08564DC@.microsoft.com...
> My friend has installed a copy of SBS Standard and is using SharedPortal
Server which is using MSDE to store its data. As he expects the database to
grow, he wishes to move the files off the C-drive (the default location) to
a larger data drive.
> How do you go about backing up and moving MSDE database's to a new
location?
> Any help would be much appreciated.
> Thank you in advance.
>
you can achive the desired result both restoring a database backp to a new
location and/or detaching/reattaching the dbs..
here you can find some useful info...
Moving DB's between Servers
http://www.support.microsoft.com/?id=314546
Moving SQL Server Databases to a New Location with Detach/Attach
http://www.support.microsoft.com/?id=224071
Using WITH MOVE in a Restore
http://support.microsoft.com/?id=221465
Restoring a .mdf
http://www.sqlservercentral.com/scri...p?scriptid=599
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Detach the database, move the MDF/LDF files, attach the database.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Simon M" <anonymous@.discussions.microsoft.com> wrote in message
news:CD922A26-B656-4AD1-928F-FD18D08564DC@.microsoft.com...
> My friend has installed a copy of SBS Standard and is using SharedPortal
> Server which is using MSDE to store its data. As he expects the database
> to grow, he wishes to move the files off the C-drive (the default
> location) to a larger data drive.
> How do you go about backing up and moving MSDE database's to a new
> location?
> Any help would be much appreciated.
> Thank you in advance.
> Simon
>