1
vote
2answers
982 views

How can I restore a microsoft sql server database backup to postgres?

I need to take a Microsoft SQL Server database backup (dump) file and import/restore into a PostgreSQL database. Does anybody have some sort of transform script (maybe a perl/sed/awk script) that ...
0
votes
2answers
294 views

Restore SQL db?

I have a small db that i need to restore back in time. Meaning i have the db running now, but some data have been overwritten, wo i need to restore a version from last night for instance. But when i ...
0
votes
1answer
179 views

SQL Server 2005: Row in backup, missing in database

I've got a MS-SQL 2005 backup file. When I open with a text editor, despite being binary, I can see some information I want back. Nevertheless, when I restore the backup using MS-SQL studio, the row ...
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
745 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. ...
0
votes
4answers
81 views

How can I restore a database such that I can use it on a server where I don't have the security admin role

On a SQL 2008 instance, I have a login with the dbcreator and public roles. When I restore a database onto this server, I am then unable to use that database because all the user -> login mappings in ...
1
vote
5answers
1k views

Determine LSN of database in NORECOVERY mode

I'm restoring transaction logs to a database, but need a way to know which transaction log I should start with. Typically I'll see something like this: The log in this backup set terminates at ...
1
vote
4answers
811 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 ...
1
vote
1answer
180 views

how to? Deploying a SQL 2008 backup to overwrite a database that has replication?

I am trying to figure out the proper procedure to overwrite a database with a backup of a database created on a different server. The backup has an identical schema, full text indexes, stored procs, ...
1
vote
1answer
605 views

Sharepoint - restore single document from database level backup

Have a single Sharepoint webserver backed by a SQL 2005 server. The sharepoint server has a messed up document in a document library and I have a SQL database backup from the day before. What are my ...
0
votes
2answers
169 views

SQL Server 2008 import data from SQL Server 2005 backup file

I have a SQL Server 2005 database backup file (.bak), and I want to grab the data of this file and import it to an already existing database. Since the backup file contains database information as ...
0
votes
2answers
472 views

SQL Server: Restore database, data copy-redo-undo, clarification?

I have tried to understad how database restore works in SQL Server. I have read from BOL about different phases within the restore operation but did not understand much. Can you please clarify what ...
0
votes
3answers
58 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
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 ...
0
votes
3answers
478 views

SqlServer2005, restore much slower than backup - it that to be expected?

My backup/restore was getting sluggish (different story), but looking at the duration of backup and restore, I see that the backup completes in a few seconds, while restoring completes in MINUTES. ...
1
vote
1answer
2k views

How to backup a specific SQL Server Schema's table?

In my SQL Server database, I have multiple schemas. I would like to backup only a specific schema's tables to a format that can easily be restored. Example: [dbo].[Trucks] [dbo].[Cars] ...
2
votes
1answer
79 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
259 views

Download databasename.bak file

I have downloaded databasename.bak file from my hosting company, when i tried to restore that DB file in SQL server 2008 it is keep on giving me following error. The media family on device ...
1
vote
1answer
82 views

What does SQL Server do if you select more than 1 full backup when doing a restore?

I have a backup file that contains 2 backup sets. Both backup sets are full backups. When I open SQL Server Management Studio and choose "Restore..." and pick the file as my device, it lets me pick ...
1
vote
2answers
818 views

Difficulty restoring a differential backup in SQL Server, 2 media families are expected or no files are ready for rollforward

I have sql backups copied from server A to server B on a nightly basis. We want to move the sql server from server A to server B without much downtime, but the files are very large. I assumed that ...
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 ...
0
votes
2answers
536 views

Is there a way to import a MS SQL .db.back (database backup) into PostgreSQL?

I've received MS SQL backups from a client, I'm wanting to import/restore them into a PostgreSQL environment. Is this possible?
1
vote
1answer
268 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
3answers
1k views

Sql Server 2005 restore from backup to the most recent file position

I'm trying to restore a database from disk to the most recent backup. There are four backup sets in the backup. I would like to restore the most recent one (taken today). I need to be able to do it ...
4
votes
4answers
5k views

Is the master database backup crucial for restoring MS SQL server in the event where you have to restore from backup and build database server from scratch?

I have been advise by Commvault partner support to turn off the backup of the master database as the backup failed due to the log file being lock. The following is the advise given: "The message is ...
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
3answers
4k views

How to restore MSDB database

I lost MSDB database in SQL 2005. How do I restore that?
6
votes
6answers
12k views

T-SQL Script to copy a database

I would like to find a T-SQL script-based way to copy my "PROD" database (which is read-only and consists of several filegroups) to a read/writable "EDIT" database, which I can use and edit data in. ...
8
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 ...