0
votes
2answers
1k views

Problems restoring large SQL Server 2005 database

I have a customer with a gigantic SQL Server 2005 database (almost 400GB including the log file) and a table has been unintentionally dropped. We are trying to restore to a temporary database then we ...
1
vote
4answers
1k views

User not functioning after backup and restore of database to another server in SQL Server 2005

We have a database called 'foo' on the first sql server instance called 'SQL01' that is backed up nightly via a snapshot with Snap Manager for SQL Server and then flex cloned and restored to a second ...
0
votes
3answers
76 views

How to do a single backup of SQL Server 2005 Data for out of place restore?

My problem: I got a virtual Windows XP machine with a specific database driven software installed using SQL Server 2005. A similar machine is also in use by several customers. One customer reports an ...
2
votes
1answer
81 views

How can I get the bak file and most recent diff file for every database on my SQL Server?

I need to restore about 1000 backups with the latest diff (for about 1000 databases). Some data was deleted last night in one column of a table. So I need to run a script on each restored vs current ...
1
vote
1answer
270 views

Problem with restoring a Blackberry configuration database on Microsoft SQL Server

I am attempting to restore a Blackberry configuration database on Microsoft SQL Server 2005. The command goes like this: restore database besmgmt-test from disk = "C:\besmgmt-test.bak"; with move ...
1
vote
1answer
2k views

Indefinite hang when restoring SQL 2005 database on a SQL 2008 server in EC2

I'm trying to restore a 25 GB database backup taken from a Windows 2003/SQL 2005 machine to a Windows 2008/SQL 2008 machine in the Amazon EC2 cloud, using a .bak file and the SQL Management Studio. ...
2
votes
2answers
185 views

benefits of periodic backup and restores on SQLServer

In the olden days when I used to use other database platforms, we were advised to back up and restore our databases periodically to improve performance. Common reasons were that a B & R would ...
3
votes
6answers
867 views

How do I restore to a SQL backup I made two days ago?

Database disasters only happen to other people, right? RIGHT?!? I'm sure this has never happened to anyone since the beginning of computer history, but, believe it or not, I'm having a problem with a ...
0
votes
3answers
4k views

How to restore MSDB database

I lost MSDB database in SQL 2005. How do I restore that?
9
votes
8answers
29k views

SQL Server restore a backup results in an error

I have a database in dev (SQL Server 2005 on Windows Server 2008) that I need to move to prod (SQL Server 2000 on Windows Server 2003). My process is as follows: Login to dev, open SQL Server ...