May 28, 2009 at 3:33 am
Hi,
iam new to DB back ups, but i need to work for it.
we have a live DB and need to push data for every 2 hrs to test DB(which is on same server) and test DB is used as an back up and also for reporting.
Here tables of DB don't have PK's and not suitable for transactional replication.
There is limited space available on system so snap shot is not feasible as it locks up much resources.
My option is log shipping.
is my option of using log shipping is correct?
is it works fine if both DB's are on same server?
thanks
--Ravi
May 28, 2009 at 4:35 am
If am not wrong, YES. You can go with Log Shipping.
It should work fine even if both DBs are in same server.
but second database will be in either NoRecovery or Standby mode. you will have to share a folder to copy the backupfile in the same server.
May 28, 2009 at 6:46 am
With the log shipped copy you are not going to be able to perform reporting functions as the database will not be available in that manner.
Why logship to the same server? The point is for disaster recovery, which you will not achieve by having both in the same physical location.
May 28, 2009 at 6:55 am
thanks for u reply.
here one should not touch live DB and we need to put another DB(testDB) on the same server and required to push data for every 2 hrs to test DB.Test DB is used for reporting purpose.
What shall i implement for?
May 28, 2009 at 7:39 am
Yes ...go with Log shipping.
Specify the logbackup restoration latency for 2 hrs in the log shipping configuration.And also to use the database for reporting purposes keep it in standby/readonly mode and not in norecovery mode.All these options are within the configuration wizard itself.So just go ahead...
May 28, 2009 at 7:41 am
Sorry, I'm a little confused as to why you are looking to have a separate database for reporting. What is the reason behind this?
Log shipping will not work based upon your requirements mentioned. You say that there is no facility for snapshots. Have you considered using procedures or SSIS to copy data into the other database table on a regular basis depending upon DML changes?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply