Tagged Questions

0
votes
1answer
60 views

Steps to recreate SQL Server Instance

I'm writing a disaster recovery protocol at work - a protocol that describes how to create a SQL Server instance from scratch in case that the PROD server will be unavailable. We have SQL Server 2008 ...
0
votes
2answers
258 views

Hyper-V and Fail over cluster 2 nodes Virtualizing DC and Secondery DC

I am building a new network for a company from scratch (50 user/Computer) They need 1-Domain Controler ( Only one Domain at the moment ) 2-MS Exechange Server 3-File Server 4-SQL/Database Server ...
0
votes
1answer
45 views

Does SQL Agent need to be running in order to take manual SQL backups?

If we have a situation where SQL Agent fails to start, will we still be able to take a full manual SQL backup? I don't mean scheduled backups and maintenance plans, just plain Right Click > Tasks > ...
5
votes
3answers
213 views

How can you recover a SQL Server database if the ldf file has been deleted

We had a drive die and lost the ldf file, but the mdf file is in tact. Is there a process for re-connecting to the mdf file, considering the ldf lost? I have searched without much luck.
0
votes
1answer
209 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
2answers
148 views

If DBCC CheckDB says my database is OK, is it OK?

I'm thinking my way through some disaster recovery scenarios. How does this one sound? A server running SQL Server 2008 or 2005 suddenly loses power (e.g. the plug gets pulled) When turned back on, ...
2
votes
1answer
1k views

Sql Server differential backup : Simple vs Full recovery model

I need to better understand the backup process under SQL Server 2008. Since drive space is a kind of matter for us and we want to have a better disaster recovery solution, I decided that we will ...
0
votes
1answer
138 views

What is the BRU Server Disaster Recovery Procedure?

How do I go about performing a full, bare metal disaster recovery from BRU Server backups? I have backed up the entire C:\ (including Windows, Program Files etc) of a test machine (using Open File ...
2
votes
2answers
197 views

Do MSDTC and disaster recovery go together?

Our application writes to multiple Sql Server databases within a distributed transaction. The Ops guys are saying that this messes up their disaster recovery plan because while the transactions on the ...
2
votes
1answer
2k views

How do I get an SQL Database in “Mirrored, Disconnected / In Recovery” into service?

I have an SQL Server 2005 mirrored database, with just the primary and secondary servers, no witness. Tonight the primary has gone down and will not be back on-line for some time yet. The secondary ...
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
462 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 ...
1
vote
4answers
559 views

SQL Server DR Strategies with virtualisation & multi sites

I'm looking for advice on the best HA/DR strategies for SQL Server. Currently I'm using Express edition with backups being copied over a the WAN to a remote site and being restored. The SQL Express ...
3
votes
5answers
745 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 ...
4
votes
4answers
475 views

Last time SQL Server downtime or data-loss occured, what happened?

This isn't a question about how to cope with or limit downtime or data-loss, I know all about that. I'm putting together a 'stories' section for my PASS post-con on disaster recovery and I'd like to ...
3
votes
2answers
423 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 ...