Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-22 : 23:40:41
|
Administrator writes "Scenario: Two servers with MS SQL Server Standard edition at two locations. Location 1 has the publisher and distributor [Merge Replication]. Location 1 is on RAID 5. Location 2 is the subscriber as well has tables which does not get published.
Problem 1: The hard disk of Loc 2 is getting full. A new harddisk has been installed. The current hard disk has two partitions C: and E: . The Database and Transaction log is on the E: . The new drive is F: . Need to move the Database only fron E: to F: while keeping the transaction log on E:.
The same procedure will be needed for Loc1 after a few months. But loc 1 has the publisher and distributor. Will moving these database on either location affect replication. Please advice as to what to do in both situations.
Problem 2: Backups need to be taken for both server (Complete, Differential,Transactional log). As of date only a complete backup is being taken at both locations.
If a job is created for each type of back up eg. a complete backup at 12 midnight, a differential backup every hour and transactional log backup every 15 minutes, will there be a clash betwee the trasaction log backup and the other backups?? Eg the 12 midnight complete backup will start and continue for around 15 mins. IF the Transaction log backup starts at 12.02 midnight then it midnight then it is bound to clash. Is setting the job to retry on faliure the best options. What is the best procedure to follow. (Note :There is only one tape drive per server.
" |
|
|
|
|
|
MS SQL Server 7.0