Friday, March 30, 2012

Log Shipping two Databases

Hi,
Is it possible to sepup log shipping for two databases on one server?
I have already setup logshipping for one database and it is working
fine. I need to setup logshipping for the second database that is on
the
same primary server. But while doing this is using the same schedule
for both databases but i want different schedules.
Can I logship it to same secondary server?
Thanks.
ParveenYes. Can you describe what you are doing when you set this up?
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
<Parveen.Beniwal.Daffodil@.gmail.com> wrote in message
news:1146027423.468492.140520@.j33g2000cwa.googlegroups.com...
> Hi,
> Is it possible to sepup log shipping for two databases on one server?
> I have already setup logshipping for one database and it is working
> fine. I need to setup logshipping for the second database that is on
> the
> same primary server. But while doing this is using the same schedule
> for both databases but i want different schedules.
> Can I logship it to same secondary server?
> Thanks.
> Parveen
>|||Hi mike
yes sure,I am having a database Test on SERVER1 and i want to
transfer Log backups of Test to a secondry Server SERVER2 on Databases
Test and Test1 both are read-only restored databases. Jobs according to
that configuration are as follows:
SERVER1:
LSAlert_SERVER1
LSBackup_Test
SERVER2:
LSAlert_SERVER1
LSCopy_SERVER1_Test
LSRestore_SERVER1_Test
As above SERVER2 is having jobs only for one database not for the
second one that is Test1 to which i want to restore at some different
schedule. But i want log shpping for the both databases on a different
schedule.
How it is possible ?
Parveen|||I'm not sure what isn't working. In Management Studio, right click on the
Test database, select properties, and set it up for log shipping. Then rigt
click the test1 database, select properties, and set it up for log shipping.
A separate backup job is createdfor each database. You also get a separate
copy and restore job for each database. So, there are no issues with having
differet schedules.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Parv" <Parveen.Beniwal.Daffodil@.gmail.com> wrote in message
news:1146197628.535252.55870@.u72g2000cwu.googlegroups.com...
> Hi mike
> yes sure,I am having a database Test on SERVER1 and i want to
> transfer Log backups of Test to a secondry Server SERVER2 on Databases
> Test and Test1 both are read-only restored databases. Jobs according to
> that configuration are as follows:
> SERVER1:
> LSAlert_SERVER1
> LSBackup_Test
> SERVER2:
> LSAlert_SERVER1
> LSCopy_SERVER1_Test
> LSRestore_SERVER1_Test
> As above SERVER2 is having jobs only for one database not for the
> second one that is Test1 to which i want to restore at some different
> schedule. But i want log shpping for the both databases on a different
> schedule.
> How it is possible ?
> Parveen
>|||Hi mike
I think you are not getting my problem i want to transport
backup of Test on SERVER1 to two databases Test and Test1 on the
SERVER2 on a different schedule. I mean
SERVER1:
Test publisher databases whose Backup is to take.
SERVER2:
Test restore backup here after every 45 mins
Test1 restore backup here after every 75 mins
But jobs on the SERVER2 are created for the restoration of the
Test on Test only not for the Test1 Database. How it is possible ?
Parveen|||Right click the database you are backing up. Select properties. Select the
Transaction Log Shipping tab. Look in the middle of the screen. You can
add as many targets to this as you choose to add. So, you just have to add
another entry to this for the other database and it can be configured with
its own schedule.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Parv" <Parveen.Beniwal.Daffodil@.gmail.com> wrote in message
news:1146206287.127394.183270@.i39g2000cwa.googlegroups.com...
> Hi mike
> I think you are not getting my problem i want to transport
> backup of Test on SERVER1 to two databases Test and Test1 on the
> SERVER2 on a different schedule. I mean
> SERVER1:
> Test publisher databases whose Backup is to take.
> SERVER2:
> Test restore backup here after every 45 mins
> Test1 restore backup here after every 75 mins
> But jobs on the SERVER2 are created for the restoration of the
> Test on Test only not for the Test1 Database. How it is possible ?
> Parveen
>

No comments:

Post a Comment