Reloading a database from a backup, typically for disaster recovery, or to make a copy of a database onto another server.

learn more… | top users | synonyms (2)

4
votes
3answers
2k views

Restore a SQL Server database to an offline copy

I have SQL Server Management Studio. I need to access a backup file (*.bak). How do I create a new database engine that is OFFLINE (running from my PC not the server) and then restore the database ...
1
vote
4answers
6k views

Database Restore Failed Due to Incompatible Version of SQL Server [duplicate]

I am working on different two SQL Server, I need to transfer database from one server to another but problem is the servers have different versions. Below is image of error message. Using SELECT ...
1
vote
2answers
1k views

SQL Server 2012, triggers missing after restore database

I am using MS SQL Management Studio 2012 to restore the database from a .bak file. (That file is from the backup of the database on server) In my new database, the triggers are missing. Why did I ...
3
votes
2answers
122 views

Prevent logins loss when restoring a database

I'm backuping and restoring databases accross two sql server (v12.0.2000). But it looks like whenever I restore a .bak file, the login I created on the database that was backuped is no more existent ...
1
vote
0answers
168 views

Preferred third party SQL Server backup tool? [closed]

Can anyone list their preferred third party SQL Server (with SQL Server 2012 support) tool? My organization is considering utilizing a third party tool to gain some speed and flexibility for our ...
3
votes
1answer
63 views

Automate DBs restore through TSQL by given folders

I searched in the internet but cannot find clear and direct way. I have a folder which include 100 databases as full backup, another folder contains all logs for these 100 DBs. I need a script to do ...
5
votes
4answers
3k views

SQL Server DB restore fails

I am trying to do a SQL Server database restore using this T-SQL code: ----Make Database to single user Mode ALTER DATABASE xyz SET SINGLE_USER WITH ROLLBACK IMMEDIATE ----Restore Database RESTORE ...
1
vote
0answers
34 views

Managing logs generated by user

I am developing a web app for my client and there is a section which displays the changes made in the application by any of the user. This section is known as log.It basically stores and displays the ...
0
votes
1answer
288 views

mysqlbinlog recovery table wise

I am going to restore my MySQL database table using log files. My database name is "decsys" . I have already created sql using log files C:\wamp\bin\mysql\mysql5.5.8\bin>mysqlbinlog -d decsys ...
13
votes
5answers
69k views

media family on device is incorrectly formed. SQL Server cannot process this media family

I am trying to restore a .BAK in SQL server but get the following error: Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot ...
3
votes
3answers
4k views

Verify mysqldump backup is corruption free

We've got a cron task backing up our Database using mysqldump - my main concern is corruption, short of manually importing and checking the backups each time whats the best way to check / verify a ...
1
vote
2answers
624 views

How to restore a “contained” database? [closed]

I recently tried to restore to my local development SQL Server a backup from a network instance. To my surprised I received the following error message: Msg 12824, Level 16, State 1, Line 3 The ...
4
votes
1answer
131 views

Restoring database without worring about partitions

On our our production database there is a partitioned table called FullLog. This is updated via triggers so we know who changed the database and when. Which is a problem for me when I restore the ...
0
votes
1answer
196 views

fn_dblog not showing up deleted table data

I unintentionally deleted 4 rows from a table. I tried to fetch back the deleted data using a stored procedure (got from internet). However, I was able to see my data in the result of stored ...
1
vote
2answers
103 views

ALTER DATABASE script preventing restore of MySQL database in another server

While backing up the database with mysqldump --routines options, I see ALTER DATABASE in the middle of the output dump, near the routines. /*!50003 DROP FUNCTION IF EXISTS `f_my_function` */; ALTER ...
4
votes
0answers
89 views

Torn page SQL Server 2008 R2 RTM

DBCC results for 'bad_db'. Msg 8939, Level 16, State 98, Line 1 Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -6794535623816839168 (type Unknown), page (26876:998677113). Test ...
0
votes
0answers
74 views

Best way to restore 400GB+ worth of data in MySQL 5.6

So I'm trying to figure what the best/quickest way would be to refresh a massive amount of data. We're wanting to copy 3 months worth of data from a replication server to a QA server for product ...
3
votes
2answers
53 views

Which Log should I start backups with?

We have log backups running every 15 minutes and nightly fulls/diffs (fulls are once a week per DB, but they are spread across the whole week for load balancing). Lets say for a particular DB I have a ...
2
votes
2answers
79 views

Which method is better to drop all user connections before a restore Change to single user mode or Take offline the database?

When we restore a database from prod to dev which method is better to disconnect other connection accessing the database? I am on SQL Server 2008r2 1. Change to Single user mode use master Go ...
2
votes
2answers
2k views

The log in this backup set is too recent, but it's from before the last full backup!

I'm trying to restore a full database backup plus transaction logs to the most recent transaction log. I've set up transaction logs to ship out every 15 minutes. This setup was performed via the SMSS ...
1
vote
2answers
72 views

Restore a newer filegroup backup

So this is my set up. In our data warehouse we have mostly tables that are filled with data from a ETL-process. We do not take backup of these tables since we have an option to do a full reset using ...
3
votes
1answer
843 views

How to check the status of log file restore for SQL Server

Used this script to restore a full backup (about 30GB of data and 100GB log) on a SQL Server 2012 box: RESTORE DATABASE [dbname] FROM DISK = N'S:\import\dbname_201505131100.bak' WITH FILE = 1, MOVE ...
2
votes
1answer
226 views

Aborted restoring from back up Sql Server 2008

I started restoring from backup using (WITH REPLACE, RESTORE WITH RECOVERY) and realized that it was a mistake, so I stopped restoring. Now this db is unavailable and has a 'Restoring' status. Can ...
2
votes
2answers
241 views

History of database restore completion times?

I'm trying to estimate the restore time for a few 1TB+ databases on SQL 2012. Is it possible to look at completed restores from the last year and list the completion time ? It's an odd remote server ...
-2
votes
1answer
811 views

How to restore a database from a .bak file to an existing database via GUI? [closed]

How can I restore a database from a .bak file to an existing database via the GUI instead of using the commands? Will the database be inconsistent if I restore a previous backup and what will happen ...
0
votes
1answer
67 views

SQL Server 2008 R2 - Moving nodes in mirrored environment

Was hoping that I would find this documented somewhere, but I've searched and searched. Finally asking the question myself: I have SQL Server 2008 R2 in a HA setup (primary/mirror/witness) I want to ...
2
votes
0answers
41 views

DB backup is not being restored to another DB. It is showing “Specified cast is not valid” error [closed]

I have been experiencing "Specified cast is not valid" error while restoring backup of DB. Version of SQL server management tool from which I am taking the backup is "Microsoft SQL Server 2008 R2 ...
0
votes
0answers
330 views

after a crash and disk i/o error, mysql won't start

We had an i/o error (don't know yet why) but we restarted the server, run an fsck and everything seemed to be fixed, the server booted ok, just that mysql doesn't want to start. Nothing works, we have ...
4
votes
2answers
167 views

Have full SQL Server restore but losing 1 day of data

I have SQL 2008 R2 64bit and it is backed up with ASIGRA SQL backup. The issue I have is that we had corruption on the server and the DB got corrupted yet the LDF file is in tact and does have all the ...
0
votes
1answer
51 views

Restore user db from UNC

I need to create a job that restores all user databases from UNC to my SQL Server. All the backups, for 3 days, are located in the same folder and I need to restore the last modified backup. What is ...
2
votes
1answer
229 views

Couldn't restore database and couldn't change Single user mode to Multi user mode

I am unable to restore a database. The database is stuck in single user mode. I cannot change to multi-user mode. I was restoring the SQL Server database from Prod to Dev as I have done many times ...
2
votes
2answers
67 views

Database recovery procedure

I recovered a database with last full backup, all differentials after the full, and then all log backups after the last differential. Can I trust the database is right or do I have to do it again the ...
1
vote
1answer
40 views

Recover deleted data SQL Server

On 03/19 one user had deleted the data from 3 tables from one of the databases that we have. Now we have the full backup of that database each day. What we want to do is to restore the deleted data ...
1
vote
1answer
76 views

Possible to restore a damaged database's PRIMARY filegroup only?

I have a database (MyDatabase) with 2 filegroups, [PRIMARY] and [SECONDARY]. The [SECONDARY] filegroup has 2 datafiles, [DataFileA] and [DataFileB]. [DataFileA] is damaged (even after DBCC CHECKDB ...
2
votes
1answer
238 views

BACKUP AND RESTORE FileGroup (PRIMARY) - WHY after restore I still see Other FileGroups?

/********************************** CREATE DATABASE PiecemealDB *************************************/ use [master] go if exists (select * from sys.databases where database_id = DB_ID('PiecemealDB')) ...
3
votes
2answers
2k views

ERROR 1100 (HY000) at line 11084: Table 'search_index' was not locked with LOCK TABLES

I'm trying to import a mysqldump backup of a drupal database taken from a server running MySQL 5.0 (which will be upgraded to 5.5) onto my local machine running MySQL 5.5.23. The import fails with the ...
9
votes
6answers
3k views

Migrate from SQL Server 2000 to 2012 without a 2005 or 2008 instance

I have come across three old databases sitting on SQL Server 2000 which I need to move to 2012. I believe the standard approach is to restore into a 2005 or 2008 instance, update, re-export and ...
1
vote
1answer
100 views

Fail to attach database : MSDTC Check status of transaction

I am attaching a database from a snapshot taken of the production database volumes. These databases will be anonymised and then restored to our DEV servers. Here is my attach statement: CREATE ...
3
votes
0answers
91 views

Restoring Postgres fixtures into a different database with different premissions

I've got an application called BigSense that uses two database users/rolls. One has full permissions and is used by my application to create/adjust table definitions. Then the application starts with ...
2
votes
1answer
3k views

pg_restore: [archiver (db)] could not execute query: ERROR: schema “public” already exists

I am using pg_dump / pg_restore to backup and restore a PostgreSQL database, but am getting some error messages (and a non-zero exit status) from pg_restore. I tried a super simple base case (outlined ...
0
votes
0answers
38 views

manual data migration/rescue MySQL version: 5.6.23

MySQL died and could not be started. So I transferred my database files via rsync to another server and restore from back up. Now I am trying to access my data with my updated records. mysql> use ...
0
votes
1answer
373 views

Restoring SQL Server 2012 DB - OPEN SYMMETRIC KEY SKey DECRYPTION BY CERTIFICATE NAME Not working

Database Admins, can you please help me out and let me know why my script is not allowing me to DECRYPTBYKEY once I restore my DB from a PRODUCTION BACKUP.... -- SET Staging to Single User Mode to be ...
0
votes
0answers
42 views

Cant Import mysql system DB from another server

Both Servers are the same in hardware, OS, and MySQL versions (5.6.11). One server has MySQL on it and on the other one I just setup a fresh instance. I want to import all of the data to the second ...
2
votes
1answer
114 views

Use transaction logs multiple times

Every night a full backup is made of all the user databases. Every 15 minutes, transaction logs are created. Today i succesfully restored a database with the use of transaction logs. I set the time ...
3
votes
2answers
136 views

What perfmon counters should I use to get the fastest restore possible on an idle system?

I have a development VM running Windows 2012-R2 and Sql Server 2014. I have one disk from a SAN holding the OS and SQL. My backup file is stored locally on the disk. I want to restore database as ...
2
votes
1answer
199 views

SQL Server Restore w/o “Closing Existing Connections”

By default in SSMS (2012/2014) when you choose to restore a database, the "close existing connections" option located in the is by default unchecked, is it possible to restore a database while ...
-1
votes
1answer
5k views

Restoring a backup of a database from SQL Server 2014 into SQL Server 2012 [duplicate]

Is it possible to load a backup of SQL server 2014db into SQL server 2012? Trying to import/restore is throwing backward compatibility issues. Thanks
1
vote
5answers
211 views

Getting Data Back after Wrong Data Restore in SQL Server

I would like to inquire if there is an possible way to return lost data that stored in a Sql server Database after making a wrong database restore? I know it is extremely hard to get a positive ...
2
votes
1answer
258 views

How to get back the PostgreSQL database to a specific point in time?

I was running a batch script in a PostgreSQL database which inserted values in different tables between 10:40 and 11:00. Later I came to know that the script was executed mistakenly. How can I get ...
0
votes
0answers
64 views

Powershell error: “Cannot convert the ”[DBADEV\SQL2008r2]“ value of type ”Microsoft.SqlServer.Management.Smo.Server“ to type… ”

Error I'm getting from Powershell: Cannot convert argument "srv", with value: "[DBADEV\SQL2008r2]", for "SqlBackup" to type "Microsoft.SqlServer.Management.Smo.Server": "Cannot convert the ...