RE: Using a HEX differential when moving data files.

From: Vikram Jayaram [MS] (vikramj_at_online.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 20:15:19 GMT

See if these articles help -

246133 INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/?id=246133

314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546

240872 HOW TO: Resolve Permission Issues When You Move a Database Between
http://support.microsoft.com/?id=240872

274463 INF: Understanding and Troubleshooting the Copy Database Wizard in
SQL
http://support.microsoft.com/?id=274463

---------------- Between copying your mdf/ldf files and restoring, I dont
know if we;ll be saving a considerable amt of time. Esp if your backups are
taken on a tape or such media that you can attach to the new machine.

Vikram Jayaram
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Relevant Pages

  • RE: Logging into a restored db
    ... Start with reviewing these articles to get a better understanding why you are seeing the ... 224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach http://support.microsoft.com/?id=224071 ... 274463 INF: Understanding and Troubleshooting the Copy Database Wizard in SQL http://support.microsoft.com/?id=274463 ...
    (microsoft.public.sqlserver.security)
  • Re: Upgrading database
    ... INF: Moving SQL Server databases to a new location with Detach/Attach ... How to Resolve Permission Issues When a Database Is Moved Between SQL Servers ... Mapsids.exe Helps Map SIDs Between User and Master Databases When Database Is Moved ...
    (microsoft.public.sqlserver.server)
  • Re: All security permission in my new SQL server.
    ... 224071 INF: Moving SQL Server Databases to a New Location with Detach/Attach http://support.microsoft.com/?id=224071 ... 221465 INF: Using the WITH MOVE Option with the RESTORE Statement http://support.microsoft.com/?id=221465 ... 274463 INF: Understanding and Troubleshooting the Copy Database Wizard in SQL http://support.microsoft.com/?id=274463 ...
    (microsoft.public.sqlserver.security)
  • Re: User who does not exist in Enterprise Manager has full access
    ... impede Windows NT administrators from administering a clustered ... Move Databases Between Computers That Are Running SQL Server ... 221465 INF: Using the WITH MOVE Option with the RESTORE Statement ... Resolve Permission Issues When You Move a Database Between ...
    (microsoft.public.sqlserver.security)
  • RE: SMS Site Server backup when SQL database is placed in another
    ... "two sites can use the same computer that is running SQL Server if they have ... SMS site server." ... >> Yes they should be there regardless of where the SQL database is located. ...
    (microsoft.public.sms.admin)
Quantcast