RE: Moving databases between servers

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mike Epprecht (SQL MVP) (mike_at_epprecht.net)
Date: 12/07/04 

Date: Tue, 7 Dec 2004 05:33:02 -0800

Hi

The drive letters can be different. If the drive letters/paths are not the
same, you need to use the WITH MOVE option with the RESTORE command.

Look at the archives for "log shipping" for additional information.

Regards
Mike

"Eilish" wrote:

> Hi,
>
> I would like to configure a 2nd server for data recovery, I know that they
> need to be configured the same but can you tell me why
>
> 1. Make sure the new server has the exact same drive letters with at least
> same or more disk space, as the old server.
> 2. If the SQL database is on different drive letters what are the
> implications and how could the server be configured properly.
>
> Many thanks

Relevant Pages

  • Re: How does a regular user (not a "server" guy) use Active Directory to make their job ea
    ... >> If they're used to drive letters, that could be a good way. ... > folder being redirected -anywhere- onto the server. ... >>> DFS to make things easier; and that publishes to Active Directory. ... especially is you're in transition from NetWare. ...
    (microsoft.public.windows.server.general)
  • Re: mapping verses shared folders
    ... the new server and I don't want to do alot of reconfiguring. ... to change the office directory to modify for the domain users. ... >> would not have a mapped drive showing up just shared folders. ... > Well, I like drive letters, because if I want to move something to another ...
    (microsoft.public.windows.server.general)
  • Re: Mapped Drive Letters
    ... > when a user logs in a global script maps certain drive letters to folders ... > the file server. ... script to map drive letters to file shares on a server. ...
    (microsoft.public.windows.server.setup)
  • Re: Mapped Drive Letters
    ... >when a user logs in a global script maps certain drive letters to folders on ... >Can I do the same on 2003 server so that some applications can use the same ... Be aware that in Windows, mappings must be to shares and not ...
    (microsoft.public.windows.server.setup)
  • Re: Maximum disk storage under 2000/2003 Server
    ... Microsoft talks about Win2003 Storage Server ... > that can support up to 40 terabytes. ... >> you have remaining available drive letters for. ... drive) or separate physical drives (again, ...
    (microsoft.public.windows.server.general)