File locations

Is it possible to reassign the data and transaction log file locations after
creating a DB? If so how? Thanks to everyone for being there to help. SQL
server 2000
Simplest way would be to detach the database, move it to a new location an
then attach it again (not recommended for a production database).
Cristian Lefter, SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
|||Cristian's advice is sound but you may find these helpful:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
> after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL
> server 2000
|||Hi,
1. Use the procedure SP_DETACH_DB <dbname> to detach the database
2. Create a new folder in new drive and copy the MDF and LDF to new folder
3. Use sp_attach_db
'dbname','driveletter\folder\dXbname.mdf','drivele tter\folderX\dbname.ldf'
FYI, This approach need some down time.
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:D2874151-8BF6-424F-A1A9-A17C2F175374@.microsoft.com...
> Is it possible to reassign the data and transaction log file locations
after
> creating a DB? If so how? Thanks to everyone for being there to help. SQL

> server 2000