0
votes
1answer
70 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 ...
1
vote
2answers
3k views

How to start MSSQL Server with corrupt model db

After moving some databases around (restoring, deleting, etc) we experienced an issue creating new databases. Specifically, When trying to create a new database MSSQL Server it failed because the "The ...
0
votes
1answer
62 views

Restoring SQL Server 2008 R2

I am running SQL Server 2008 R2 Standard Edition on a Windows Server 2008 R2 Enterprise. I'm using the standard backup and restore for the server portion and the native SQL Backups for the databases. ...
1
vote
1answer
335 views

Biztalk 2009 logshipping with SQL 2008

I am setting up biztalk logshipping for Biztalk 2009 database. Following http://msdn.microsoft.com/en-us/library/aa560961.aspx article, I am doing the following to setup biztalk logshipping on ...
1
vote
2answers
78 views

Reinstalled Windows on my development box, forgot to backup any of my work in progress databases in SQL Server Express 2008? Can i recover anything?

Reinstalled Windows on my development box, forgot to backup any of my work in progress databases in SQL Server Express 2008? Can i recover anything? I still have the files from the old install. Where ...
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 ...
4
votes
2answers
333 views

Scripting an automated SQLServer 2008 DR move

We use the built in logshipping in SQLServer to logship to our DR site but once in a month do a DR test which requires us to move back and forth between our Live and BAckup servers. We run multiple ...
2
votes
2answers
396 views

Disaster Recovery for SQL 2008 with only the log file

When you read this, you just might cry... We wrote a SharePoint intranet app for the one of our clients that keeps track of files and manages them through various levels of approval. Several files ...
0
votes
4answers
409 views

Log Shipping multiple database SQLServer 2008 Standard

We currently use a fairly basic script we wrote to log ship our databases to our DR site (and back again) but want to move to a better solution. We initially discounted the inbuilt logshipping ...