• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

MS SQL logshipping

Hello Experts

We are going to setup a logshipping between our primary SQL server and DR site. let's say this is about database1 . that's the only database that needs log shipping.

1- We wanted to use same SQL server installation in DR site to run more databases (like database 2 ,3 ) for general purposes with other softwares . would that be possible ?

2- Once settiing up logshipping , I know that the process needs an extra SQL server to watch and monitor logshipping process. can that database server be used for other SQL instances ? (like run some databases as well) or it needs to be dedicated.
0
akhalighi
Asked:
akhalighi
2 Solutions
 
Aaron ShiloChief Database ArchitectCommented:
hi

simply yes you can.

you can use the same server and add more databases as long as your server performance dosent drop below your acceptable levels.
0
 
dba2dbaCommented:
1- We wanted to use same SQL server installation in DR site to run more databases (like database 2 ,3 ) for general purposes with other softwares . would that be possible ?

You can very well use the DR Server for other purposes as LogShipping is only at the Database Level and does not have any impact on other databases.

2- Once settiing up logshipping , I know that the process needs an extra SQL server to watch and monitor logshipping process. can that database server be used for other SQL instances ? (like run some databases as well) or it needs to be dedicated.

You can have a separate monitor Server other than the primary or secondary Servers Or use one of them as monitor Server.

A normal practice (though, not the best way to do it) is to setup the secondary server as monitot server.

Thanks,
0
 
akhalighiAuthor Commented:
Thanks .. so there is no need for an extra sql server , seconday can receive logshipping and act as a monitor too ?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now