December 16, 2009 at 12:29 pm
Hi All,
I have newly joined a company and here for a couple of servers we have the backups and the log files on the same drive. I have told them that if that drive fails then we will be in a situation where we won’t be having even the backups for recovery.
We are planning to move the databases to a SAN.
We also have replication configured for a couple of databases on the server.
We have a maintenance window to create Vdisks and to move the DB, logs and backup to the 3 virtual disks supplied.
This is what I am thinking. Please let me know if it’s the right approach or not. If not can you guys please guide me the steps to move the databases to a SAN.
Steps.
•Backup all the databases (user databases and the system databases) on the server 1 and store them in a secure Location.
•Change the Start up type of Sql Server Service and sql server Agent service to Manual.
•Stop the Replication on the server 1 and then on Server 2
(it’s a peer to peer replication)
•Stop The Sql server service and the sql server Agent service on the server 1.
•----- System administrator and Storage Admin steps------
•Once the New drives are presented to the server, Copy the Contents in the D: drive and the E: Drive to the new drives.
(D holds the data files and E hosts the log files)
•SA to change the drive letters of the Old Drives and rename the new drives as D: and E:
•Start the Sql server Service and the Sql server Agent service.
•Start the Replication on the both the servers and ensure that everything works
•Once ensuring everything is normal on the database side, change the maintenance plan of the backups to the new backup drive .
December 16, 2009 at 1:48 pm
vky3 (12/16/2009)
Hi All,I have newly joined a company and here for a couple of servers we have the backups and the log files on the same drive. I have told them that if that drive fails then we will be in a situation where we won’t be having even the backups for recovery.
Don't you copy the backup files to tape each night ? If not, copy them to another drive somewhere.
December 16, 2009 at 2:54 pm
We do have a nightly process that copies the backups onto the tape. But what if i want point in time data... It would not be possible taking the existing scenario into consideration and moreover ,since backups are also being copied to the same drive as the log files, we are having problems managing the drive space.
I dont think its a good practice to have both logs and backups on the same drive.
December 17, 2009 at 10:59 am
>>SA to change the drive letters of the Old Drives and rename the new drives as D: and E:
Probably will work but the rename is not necessary.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply