Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [restore]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
39 views

Restore plan cache and buffer pool after database restore? [duplicate]

When restoring a database, is there a way to restore the plan cache so it doesn't have to be re-created during production use? Similar question: is there a way to pro-actively restore the buffer ...
0
votes
0answers
32 views

DB Maintainance Job Fails Single User Mode

we have a stored proc where we rebuild indexes and also take Backup of filegroups.Following is part of the code. But this job is failing since few weeks for error message : Error : Executing the ...
1
vote
1answer
54 views

Backup too big to restore

I have a backup which in file explorer is roughly 160GB. If I run select sum((size*8)/1024) From sys.database_files where type=0 I get a result of 169493, fine. When I try to restore this ...
1
vote
0answers
22 views

How to force SQL Studio not to use copy-only backups to build database restore script?

How to force SQL Studio not to use copy-only backups to build database restore script? I want to ommit copy-only backup (because it's not longer available) and force studio to use last full backup (I ...
0
votes
1answer
32 views

Restore database with Availability Groups

I have high availability enabled with two servers and when trying to restore a database I realised I had to un-synchronize the database and then remove it from the availability group. I use Ola ...
1
vote
1answer
22 views

Can you Identify the sql server name from sql backup file(.bak)?

I have a backup file from an SQL 2016 server and I need to identify which SQL server the file was created on. Is there a way to identify the original SQL server where the file originated at? Thank ...
0
votes
0answers
9 views

how to restore wal file that is in tar format in postgresql

I am trying to use incremental backup provided by postgres. It is working if I copy the WAL files as it is in another folder and then recover. But if I make .tar.gz of WAL file then try to recover db ...
0
votes
0answers
11 views

RMAN restore / recover

this is probably a simple question, but I'm not finding an answer which I deem correct. So at this organization, they take a weekly backup using RMAN, ship those to a standby server, and perform a ...
2
votes
1answer
85 views

SQL Server Restore Failing with Error Read on “M:\MSSQL\My_FULL_Backup_20190924_010558.bak” failed: 1101(A tape access reached a filemark

I have been trying to restore one of our db for the past few days without any luck. I keep getting the below error. I tried the restore during peak hours, off peak hours both by accessing the backup ...
0
votes
1answer
16 views

how to upgrade postgresql 9.0.4 to latest with minimum downtime

I have master-slave-slave setup for postgresql 9.0.4 in our production setup. We need to upgrade it to latest (11.X), so my question is what would be the procedure to do so with as little downtime as ...
0
votes
0answers
63 views

StorageEngineUsed set to TabularMetadata. For databases in this mode, you must use Tabular APIs to administer the database

I am an administrator in SSAS. I have many data warehouse servers. In some servers I have SQL Server and SSAS on the same machine. I successfully backup the SSAS databases and even check if the ...
13
votes
1answer
2k views

Temporarily moving a SQL Server 2016 database to SQL Server 2017 and then moving back. Is it possible?

If I take a backup of a database from a SQL Server 2016 instance and then restore it to a 2017 instance to do some work on it. Can I then turn around and back up that database from the 2017 instance ...
1
vote
2answers
67 views

Does restoring a database in Microsoft SQL Server add objects to Resource Database?

As far as I know the resource database contains information on all objects in its server instance, so I would think it's only natural that when you restore a database from a backup file, part of the ...
1
vote
2answers
74 views

Sql Server Restoring Process Time Takes Too Long Time

I have 7 databases on my reporting server. I restore those databases every night with differetial backups. Normally, the differential restore time was taking about 1 or 1.5 hour for each databases. ...
1
vote
1answer
59 views

What is the purpose of keeping filegroup or filestream backup in MSSQL?

I'm a new DBA for SQL SERVER. Currently I'm learning about filestream on SQL server. So I tried to restore only filegroup of filestream to other database, but I get an error message: An exception ...
2
votes
2answers
56 views

SQL Managed Instance - Cross Subscription Restores/Migration

Short Version: I am trying to restore a backup from one SQL Managed Instance to another SQL Managed Instance. These are in different subscriptions. Using Example 3 from here I can at least get it ...
3
votes
0answers
128 views

No backupset selected to restore

I have 2 cloud SQL Servers, one in Azure, one in AWS (I don't think the cloud platforms matter here but including them just to be thorough). I'm unable to restore a database from the Azure server to ...
1
vote
1answer
101 views

RESTORE database now in Emergency

We have a database that was basically used for application purposes but it was using "master" - bad indeed. We created a new database called school that is now being used (same structure as how master ...
1
vote
1answer
50 views

Incremental backup between now and backup taken one week ago

We do a full backup of our SQL Server 2012 database every night. A new developer needs an incremental (or differential) backup of a backup we took one week ago. The reason is that for them, ...
5
votes
1answer
111 views

Restore stuck in ASYNC_IO_COMPLETION

Very frequently when I restore databases the restore operation gets stuck and the wait type is ASYNC_IO_COMPLETION. It can be in such state for 10-20-30 minutes untill it proceeds to ...
0
votes
0answers
57 views

Cassandra restore fails if sstableloader is used

Starting point: new cluster, DSE 6.7.4, C* 4.0.0.674 backed UP data, which was made by Opscenter snapshot backups to remote S3 bucket (1.5TB per each node) restoring data to new cluster needs to use ...
0
votes
0answers
23 views

SQL Server Windows backup restore on centos

I have installed sql server 2017 on my centos 7 machine. I need to restore my database backups from windows machine to this machine. I could successfully run filelistonly. However, for restore, I'm ...
3
votes
2answers
96 views

How to query data in backups?

I have an ASP.NET app using SQL Server 2017. There's a bug somewhere that's causing some records to be deleted, and I'm trying to recover the data and find the cause of the bug. We take daily backups, ...
-2
votes
2answers
64 views

get data from express edition db to developer edition [closed]

How to get database in new created SSMS sql server developer edition but I don't have back up of database but mdf file and ldf file are available.
0
votes
2answers
86 views

SQL Server Backup Database not .bak file format

I've been using SQL Server 2012 for as long as I can remember. When I do a backup it's always saved as .bak file format. However, there's this other server that has SQL Server 2012 and when I do a ...
0
votes
0answers
21 views

How to prevent regular users to backup database, in Postgresql

How can I prevent/restrict regular users, that do have select rights granted on tables etc, to perform backup of Postgres database? Is there a way to enable users to connect, select, update etc. ...
0
votes
0answers
15 views

mysql db data folder restore in 5 days old backup [duplicate]

recently I had the need to install a driver on a server and because of the destination I finished uninstalling XAMPP in which I had a database that I need to recover. The fact is that after ...
0
votes
0answers
46 views

PostgreSQL does not starting up after power failure

Could not start PostgreSQL after power failure: FATAL: could not find tuple for opclass 1 PostgreSQL version: root@ubuntu:/usr/lib/postgresql/9.6/bin# ./postgres -V postgres (PostgreSQL) 9.6.1 OS ...
4
votes
2answers
95 views

Finding out who changed the owner of a database when performing a restore

A coworker who worked on restoring a backup changed the database owner from his name to 'sa' (rightly so) last night. While I had seen the his name in a SQL Server Management Studio window, I did not ...
0
votes
1answer
61 views

Error Unknown command '\U' when restoring MySQL dump on Windows

I am updating software that used MySQL 5.4.3 in its old version, and now uses MariaDB 10.2.11. So, I dumped the old data with that command: mysqldump -uroot -p --no-create-info --skip-triggers --...
1
vote
1answer
65 views

Restore of a database failed - Table does not contain an identity column

I've created a local SQL Server instance (using SQL Server 2017). I'm trying to restore a backup of a database created on a SQL Server 2012 server, for testing purposes. The problem is that it ...
0
votes
1answer
52 views

How to check there is enough disk space before overwriting a DB with restore command

I need to automate the restore of a database each night from a backup but I want to first check if there is enough disk space. In the below Microsoft link it says the verifyonly command is able to do ...
3
votes
2answers
118 views

Backup a database from Azure SQL Managed Instance and restore to on premise SQL Server

I have three databases that I am migrating to Azure SQL Managed Instance. One is a Utility database, just a small collection of generic functions and procedures. One is the OLTP database for a web ...
9
votes
1answer
168 views

How do I find the FamilyGUID of an exsting database

When executing a RESTORE command, I understand that SQL Server ensures that an existing database is not being overwritten by a different database. This check can be bypassed using REPLACE. I ...
0
votes
0answers
39 views

Corrupted Access Database

I have a big Access database, with aobout 150 Tables/Queries/Linked txt files/Macros/Modules. I was working today, and then from out of nowhere the database got corrupted. I googled, and forund that ...
0
votes
0answers
60 views

End of file reached. Error 38 in SQL. Passes verification checks

Having issues restoring a database in SSMS, error 38. The databases are transferred up to google via their Drive API. Download it on my side and has error. If I transfer it through teamviewer ...
1
vote
0answers
7 views

Mongodb - Small and Larger deployment

I read the following information from "https://docs.mongodb.com/manual/core/backups/" "mongodump and mongorestore are simple and efficient tools for backing up and restoring small MongoDB ...
2
votes
2answers
52 views

How is the behaviour of backupset in RMAN?

I found this definition on WEB: A logical grouping of backup files -- the backup pieces -- that are created when you issue an RMAN backup command. A backup set is RMAN’s name for a collection ...
5
votes
1answer
194 views

pg_ctl hangs over ssh

I am designing a process to test my postgresql 10.8 backups by restoring them to a random point in time in a throwaway virtual machine. I have been unable to fully automate the process though. I am ...
1
vote
2answers
44 views

How to verify the restored MS SQL DB from Backup matches with the source?

Once you restore the backup, how do you verify that the source and destination are in sync (schema, datatypes, number of records etc)? assuming that the source has not change. Appreciate your insights....
0
votes
1answer
92 views

SQL Server Agent Job - Unable to open Step output file. The step succeeded

I have seen many posts with "Unable to open Step output file.", but can't find any references where the step succeeded. I have my output file location set to: $(ESCAPE_SQUOTE(SQLLOGDIR))\$(...
2
votes
1answer
80 views

How to check if backups are reliable?

I generally have to restore databases to different servers after important data imports or other important and delicate database operations. I need to be sure that my backups up to that point in time ...
-3
votes
1answer
53 views

Postgres Restore [closed]

I need to restore a single schema from production postgres to test. Test database and schema already exists. The users/roles & sequences are different on prod to test and after schema is ...
0
votes
0answers
10 views

How to make replication continue to work after repairing?

I would like to share with you a problem I faced today and will be glad if you can help me to tackle that issue. The issue related to transactional replication. So, let's go step-by-step to know how ...
0
votes
1answer
80 views

Unable to restore a PostgreSQL database from a .backup file

I am using Ubuntu 18.04 and PostgreSQL. For the GUI, i am using pgadmin4 (browser version). I created a new database and when trying to restore, the following error message comes up: <!DOCTYPE ...
0
votes
1answer
25 views

Restore previous version of database in sql server

I need your help on restoring previous version of database on SQL Server. In last week I restored database 'A' in DEV server with it's production copy and didn't realize that this database 'A' in ...
1
vote
1answer
52 views

PostgreSQL - do we need to DROP the database and recreate it if we want to RESTORE it?

I worked with many different databases (SQL Server, Oracle, IBM db2) and for all of them if we have a backup it is just enough to execute RESTORE command in order to restore the data. I am beginner ...
0
votes
0answers
22 views

Log shipping - Secondary Server

I am not a SQL Server DBA but I need some advise. I am having a problem with a prod server that’s being pounded by constant queries and data mining. I have a second server that I would like to setup ...
1
vote
1answer
33 views

Legacy data migration to Always on Availability group database

In our application there is a data conversion process that brings all the legacy data to the production database. Since our database is on availability group and the migration might bring 100GB + ...
0
votes
0answers
9 views

What are the considerations when restoring an Oracle db from control file instead of RMAN catalog?

I have a customer that needs to make a testing restore of its Oracle 11.02g database. The destination host is not the source host (so the structures of directories may not be the same). They use ...