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
>

Moving Server

We are going to be moving a Windows 2003 Member server running SQL 2000 to a
different 2003 SBS domain. What if any changes will we need to make on the
SQL server to run in the new domain?"RJ" schrieb:
> We are going to be moving a Windows 2003 Member server running SQL 2000 to
a
> different 2003 SBS domain. What if any changes will we need to make on th
e
> SQL server to run in the new domain?
Change the User-Account that the SQL Server and his Agent use to a
User-Account in the new domain. That should do it (if the server keeps his
name).