Re: HELP on How to move database files
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/27/04
- Next message: Andrew J. Kelly: "Re: Memory limited to 1.24 GB"
- Previous message: John: "Restoring database error SQL 2000 2nd issue"
- In reply to: Mac Vazehgoo: "HELP on How to move database files"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 27 Aug 2004 13:31:29 -0400
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 "Mac Vazehgoo" <mahmood.vazehgoo@unisys.com> wrote in message news:cgnlre$1sd6$1@si05.rsvl.unisys.com... > For performance reason, I have decided to move my database files around. I > have tried using Attach and Detach database to move physical location of the > files successfully. > > What I want to do is to move the transaction log file to a different > location or even better get rid of it and create a new log file in its new > location. I have tried dbcc shrinkfile to truncate the log file but does > not allow me to remove it or empty it into another log file that I have > created in a new location. Any suggestion on moving/removing database > files are appreciated. > > - Mac > >
- Next message: Andrew J. Kelly: "Re: Memory limited to 1.24 GB"
- Previous message: John: "Restoring database error SQL 2000 2nd issue"
- In reply to: Mac Vazehgoo: "HELP on How to move database files"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
