1
vote
3answers
51 views

Restore MS SQL 2008 Database from files

is it possible to restore a MSSQL server by copying its directory/data files? I have a damaged hard disk and was able to salvage the C:\Program Files (x86)\SQL Server 2008\MSSQL\MSSQL10.MYDATABASE ...
2
votes
1answer
775 views

Restore SQL Server 2008 db without affecting users

When I restore a db in Sql Server 2008 R2 from data on another server, it makes a mess of the users. I have a Windows User and MsSql Login named Web_SqlA on both machines. Before the Restore, Web_SqlA ...
0
votes
3answers
1k views

SQL Server 2008 - Restore database without restoring transaction log (LDF)

I have a production database with Full recovery mode where the MDF and LDF files are approx 80GB each. We have a test server that we restore this database to on a regular basis for dev / test ...
1
vote
1answer
764 views

Restore SQL 2008 database fails with error on page xxx:xxx

This is the situation: Got a full backup (.bak file) of a SQL 2008 database, with partitions. The .bak file is 100gb. I need to restore this database on a different server, to a new database. ...
2
votes
1answer
136 views

Restore sql server 2000 database to 2008

I am not a DBA. I will be doing this for the first time. So I am not sure what all I am supposed to do? I will be restoring sql server 2000 database to sql server 2008. Are there anywhere step by ...
0
votes
1answer
465 views

SQL Server 2008 Error when restoring DB backup: “specified cast is not available”

I was using SSMS to restore a database backup onto another database in a SQL Server 2008 instance, when I received the error message: "specified cast is not available". The backup was made on a SQL ...
0
votes
1answer
255 views

How to restore database using old full backup and current log file

What is happened? My client has lost the hard disk. He has to restore database. He has the full backup of database 15 days old. He has ldf (log) file of this database. He has NOT mdf file (it was ...
1
vote
1answer
3k views

Restore SQL Server database is hanging?

I've made a Backup from a SQL Server 9.0.4053, copied the bak file to a different computer running SQL Server 10.0.2531 and tried to restore using RESTORE DATABASE [MyDatabase] FROM DISK = ...
2
votes
3answers
4k views

How to restore a SQL Server database and shrink its files at the same time?

Let's say I have a SQL Server database whose data files have been created with an initial size of 100 GB, but it only contains 10 GB of data. A database backup will then be only 10 GB in size. I want ...
2
votes
4answers
10k views

Error when restoring database (Windows 7 test environment)

I have a windows 7 operating system as a test environment. I have SQL Server EE installed with two instances, named as test and production. I took a full backup from AdventureWorks database from test ...
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. ...
1
vote
2answers
3k views

SQL Backup - Restoring to different data / log files - Changing file structure…?

I'm trying to restore a BAK of a database we have, onto new, better hardware. Here is a screenshot of the UI in Management Studio http://twitpic.com/wmtr8/full The existing db has an mdf, and ndf ...
0
votes
1answer
713 views

SQL: Restore a database that was not detached properly [closed]

I had problems with my harddisk on my dev box, yet I was able to save my MDF and LDF files. Needless to say, they were not detached properly. I tried sp_attach_single_file_db which broke down ...