0
votes
1answer
242 views

What are my SQL Server 2005 Disaster Recovery options if I can't have Enterprise edition?

We currently have a number of SQL Server 2005 Standard edition instances which support an intranet and need to be integrated into our disaster recovery plan. I was hoping to use database mirroring, on ...
0
votes
3answers
690 views

SQL Transaction log backups after Full SQL Backups

Environment: VM with 20 gb of HD space and secondary hard drive with 3 gb. Windows Server 2003 and Sql 2005 Backup Scenario: Weekly Full backups with Backupexec Nightly Diff. backups with ...
1
vote
1answer
371 views

SQL 2005 change IP address and subnet

I have to move few sql servers to a new subnet ( change IP address and mask only ), need to know what should be best practice or correct way of doing this? the sql servers are not in cluster. Thank ...
1
vote
1answer
78 views

Is there a simple way to backup and restore all Microsoft SQL Server database objects related to a particular application?

I would like to backup, not only the databases that belong to a particular application living on a shared server, but also, those things that get stored outside of the database; the server accounts, ...
1
vote
1answer
634 views

SQL Server Sync Jobs Betwen Primary and Secondary Server

I am setting up a Standby Server for disaster recovery and high availability reasons. My product relies heavily on SQL Jobs, as such, these jobs need to exist (Disabled) on the Standby server. I have ...
4
votes
4answers
260 views

Best way to replicate / mirror 100s of databases in SQL 2005

I currently host around 400-500 SQL 2005 databases of varying sizes (1-10 gig) each. I am aware of most of the different methods available and the general pros/cons of mirroring, log shipping, ...
3
votes
5answers
837 views

Licensing a SQL DR box [duplicate]

Possible Duplicate: Can you help me with my software licensing question? I'm tempted to use a DR server which holds a mirrored copy of a database to also perform test restores and integrity ...
3
votes
2answers
435 views

SQL Server 2005 Mirrored DB Recovery

Scenario: We want to use SQL Server 2005 Standard's version of DB mirroring along with a witness server in an Active Directory domain environment. The database is fed from a 3rd party app server that ...