All Questions
Tagged with restore sql-server-2012
17 questions
11
votes
6
answers
29k
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 ...
- 221
17
votes
7
answers
78k
views
Error 3154 while restoring a backup using WITH REPLACE
I have SQL 2012 with SP1 installed on my computer. I made a backup of a database test.bak.
I have a database with the name test2 which is the same database, but the data changed.
I want to restore ...
- 2,039
13
votes
1
answer
23k
views
Restoring a SQL Server 2012 database in high availability
I have a database which is in always-on high availability mode synchronized with another database on a different instance. How can I restore from a .bak file into the primary database using T-SQL?
I'...
- 133
8
votes
2
answers
36k
views
Restore a SQL Server 2012 backup file in SQL Server 2016/2014
I have SQL Server 2012 backup files and want to restore these to SQL Server 2016/2014. Will it work?
I need to find this out before I uninstall SQL Server 2012.
- 201
5
votes
1
answer
6k
views
Can I use a script to restore multiple SQL databases from .bak files?
I'm migrating 100 plus SQL databases over to a new server in a new location. I have the maintenance plan in place to take full back ups and then a script to copy over the .bak files to a temp ...
- 75
4
votes
3
answers
3k
views
Does SQL Server re-create system databases if they are lost/missing?
We have a third-party server backup tool running every 24 hours, which backs up everything (files and database in preparation for a bare-metal restore). After much investigation, it emerged that the ...
- 860
3
votes
1
answer
111
views
Tool for quickly backup and restore a table
Is there a tool for quickly backup and restore a table's data, preferably to a csv file?
It would be best if I could do it using batch. Run a .cmd file and data is backed up into a file with datetime ...
- 1,573
3
votes
1
answer
1k
views
Automating DB Restore from network share
We have a network share that uses different credentials from the currently logged in user. Inside this share we have full, differential and log backups that come through from a third party database ...
- 303
2
votes
1
answer
1k
views
SQL Availability Group restore database to standalone server
Running: SQL Server 2012, Windows Server 2008 R2
I want to test a backup by restoring onto an isolated server. The backup was taken from an Availability Group (HADR) configuration, but the target ...
- 65
8
votes
2
answers
2k
views
Shrinking a SQL Server Transaction Log
I’m currently having to deal with a SQL Server transaction log that has got out of control. Disclaimer: I’m not a dba and this isn’t my area of expertise so please bear with me.
Currently I have a ...
- 183
7
votes
1
answer
499
views
After Restoring Log Shipping to Secondary Server, First Stored Procedure Execution is Slow
We've set up log shipping to a secondary SQL server on Standby/ Read-Only to offload all SSRS report generation.
This works fine within the restrictions imposed by:
Kicking out the user during the ...
- 105
6
votes
2
answers
7k
views
Restore master database from SQL Server 2008 R2 on SQL Server 2012
I have a process that restores all my backups on a centralized server for testing. I have recently upgraded this server to SQL server 2012, and now I am getting an error when restoring master from SQL ...
- 3,322
5
votes
2
answers
1k
views
Need suggestion on Back up Strategy [closed]
Our client has agreed to an RPO of one day data loss. So I am going to change back up strategy to eliminate space constraints.
Database is in full recovery mode.
Existing backup plan:-
Once daily ...
- 195
5
votes
3
answers
31k
views
RESTORE failing with OS error 32, file being used by another process
I am writing a set of procedures for (partially) automating DB deployment for a customer, which mostly works fine, but sometimes a RESTORE command is failing with the OS error 32, about a file being ...
- 3,051
2
votes
1
answer
8k
views
Error 468 MS SQL Server : Couldn't resolve collation conflict between Arabic_CI_AI and Arabic_CI_AS when enumerating publications
When I try to expand the list of local publications under Replication element in SQ Server Management Studio, I get the following error :
Here is the detailed error log :
=============================...
- 659
1
vote
4
answers
2k
views
Restoring master database
I am trying to restore master database, when I set the server to single mode user I am unable to connect I get the error below.
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed ...
0
votes
1
answer
1k
views
Error in using sp_describe_first_result_set with Restore [closed]
Is querying the backup metadata with sp_describe_first_result_set system sp supported?
For example the query:
SELECT * FROM sys.dm_exec_describe_first_result_set (N'RESTORE HEADERONLY FROM DISK =''...
- 1,550