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
Showing posts with label reassign. Show all posts
Showing posts with label reassign. Show all posts
Friday, February 24, 2012
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 2000Simplest 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/feat...cle.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/scr...sp?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\d_bname.mdf','driveletter\folder_\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
creating a DB? If so how? Thanks to everyone for being there to help. SQL
server 2000Simplest 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/feat...cle.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/scr...sp?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\d_bname.mdf','driveletter\folder_\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
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 2000Simplest 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/features/mssql/article.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/scripts/scriptdetails.asp?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\dbname.mdf','driveletter\folder\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
creating a DB? If so how? Thanks to everyone for being there to help. SQL
server 2000Simplest 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/features/mssql/article.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/scripts/scriptdetails.asp?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\dbname.mdf','driveletter\folder\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
Subscribe to:
Posts (Atom)