Re: Adding another server instance to another hard drive?
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 05/29/04
- Previous message: Niels: "Adding another server instance to another hard drive?"
- In reply to: Niels: "Adding another server instance to another hard drive?"
- Next in thread: Niels: "Re: Adding another server instance to another hard drive?"
- Reply: Niels: "Re: Adding another server instance to another hard drive?"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 29 May 2004 09:15:04 -0400
That is what backups are for. It's much easier to simply do a backup of
each database (including Master & MSDB) and store those in a different
location. Preferably on a different machine or medium altogether, You don't
have to take the databases off line for a backup like you do with detach.
You might want to take a look at this:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx
-- Andrew J. Kelly SQL Server MVP "Niels" <nkistrup@comcast.net> wrote in message news:6v-dnY1yOZGJGCXdRVn2sQ@giganews.com... > Problem: For safety reasons, I want an exact copy of all SQL databases on > another hard drive. I'm trying to guard against a hard drive crash. > Currently, I detach, file copy to another drive, then reattach each > individual database. Since SQL Server is running on different hard drive > from the data, I know that I wouldn't have to reinstall it. > > 1) Is there a way to do what I am asking? > 2) Is this the correct the newsgroup to post these questions? > 3) Is there a book that covers this? > > Tried various keywords, but couldn't find anything in Books Online. I'm > running MS SQL Server Developer's ed. under Windows 2000 Pro. > > Niels > >
- Previous message: Niels: "Adding another server instance to another hard drive?"
- In reply to: Niels: "Adding another server instance to another hard drive?"
- Next in thread: Niels: "Re: Adding another server instance to another hard drive?"
- Reply: Niels: "Re: Adding another server instance to another hard drive?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
