Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Setup Mirroring for the first time - Large DB

 
   Database Help (Home) -> Replication RSS
Next:  Input Params in Exeucte SQL Tasks == Syntax error..  
Author Message
Mike D

External


Since: Dec 07, 2008
Posts: 6



(Msg. 1) Posted: Fri Dec 12, 2008 2:54 pm
Post subject: Setup Mirroring for the first time - Large DB
Archived from groups: microsoft>public>sqlserver>replication (more info?)

Hi, I have a 500GB database I need to mirror across a 100MB WAN, I have
tested mirroring smaller databases without issue but these DB's were not in
use, my issue is this is a very important production DB and is in constant
use so while the backup and copy to the mirror server happens (20 hour
process) things will get out of sync, I found the below:

Read below from
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm...st_prac

Initial Synchronization Between Principal and Mirror:
Prior to establishing the database mirroring session, the database must be
restored on the mirror server, and be in the Restoring state. The most common
way to achieve this is to take an online backup of the database on the
principal, copy the backup to the mirror server, and restore it on the mirror
server with the option to apply further transaction logs.
Depending on the size of the database and the distance between the two
servers, it can take a long time to copy the backup and restore it on the
mirror server. During this time, it is possible that the principal database
has produced several transaction log backups. If the principal produces lots
of transaction log backups, you need a way to copy all the transaction log
backups and apply them on the mirror. If you don’t want to bother copying and
applying so many transaction log backups on the mirror, you can suspend
transaction log backups on the principal until the database on the mirror
server is restored and the database mirroring session is established. After
the database mirroring session is established, resume transaction log backups
on the principal. One thing to note in this approach is that during the time
that transaction log backups are suspended, the log file can grow; you need
to plan for enough disk space to account for the growth of the log file.

My question is not being a DBA and assuming suspending is the easiest for me
to do how do I actually suspend it? I've searched but cannot find anything
specific that tells me, btw it's SQL 2005 Std.

Thanks in advance for any help.

Mike

 >> Stay informed about: Setup Mirroring for the first time - Large DB 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 145



(Msg. 2) Posted: Mon Dec 15, 2008 12:29 pm
Post subject: RE: Setup Mirroring for the first time - Large DB [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Mike - once you have the backup of the production database, you could take
it offline while the backup is being transferred but I don't see the need and
this sounds like it could be painful to your business. I'd take the full
backup, and then stop the log backups to make life easier. Zip up the full
backup, transfer it over to the DR site, unzip and restore in NO RECOVERY
state. Take a log backup and do the same, including the zipping and
unzipping. Then start mirroring. If there is a lot of activity on the
database, you might need another log backup transferred before starting
mirroring, but it isn't essential.
HTH,
Paul Ibison

 >> Stay informed about: Setup Mirroring for the first time - Large DB 
Back to top
Login to vote
sql_noob

External


Since: Dec 12, 2008
Posts: 9



(Msg. 3) Posted: Thu Dec 18, 2008 9:54 am
Post subject: Re: Setup Mirroring for the first time - Large DB [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Dec 15, 3:29 pm, Paul Ibison <Paul.Ibi....DeleteThis@ReplicationAnswers.Com.
(donotspam)> wrote:
> Hi Mike - once you have the backup of the production database, you could take
> it offline while the backup is being transferred but I don't see the need and
> this sounds like it could be painful to your business. I'd take the full
> backup, and then stop the log backups to make life easier. Zip up the full
> backup, transfer it over to the DR site, unzip and restore in NO RECOVERY
> state. Take a log backup and do the same, including the zipping and
> unzipping. Then start mirroring. If there is a lot of activity on the
> database, you might need another log backup transferred before starting
> mirroring, but it isn't essential.
> HTH,
> Paul Ibison

if you want to suspend log backups you do it in your backup software
or via maintenance plans, depending how you backup your databases
 >> Stay informed about: Setup Mirroring for the first time - Large DB 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
mirroring & backups - Hi, I have a mirrored databased, which is in FULL recovery mode. I take log backups every 1 hour and db backups every night. However, the log file keeps increasing and due to mirroring I can’t shrink the log with shrinkfile. Is this the recommended...

Replication or Mirroring - I'm facing some problems with the Snapshot Replication with error "StartIndex cannot be less then zero" and unable to find a solution for this. I'm seriously looking at Mirroring instead as an alternative solution. The question is since I'm ...

Database Mirroring - Is it possible to implement Database Mirroring in SQL 2000? Can someone guide me to the right resource. Thank you all. VBeachcomber

2000 to 2005 database mirroring or database snapshots? - There really wasn't a good fit for this post so I figured I would post it here. I want to setup database mirroring between a 2000 and a 2005 box. Is this possible. If not basically I need a reporting server, but if it's not are database snapshots..

differnce between mirroring and rplication - hi all i have 3 sites and i want the available all time. now i should use dissicon make replication or mirrioring. tell me the diffrence betwwn them and what is good for me. my bussines model is sendind SMS which mean that my data base should be..
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]