Linked Questions

0 votes
1 answer

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
sppc42's user avatar
  • 111
-2 votes
1 answer

Downgrade backup from SQL Server 2014 to SQL Server 2012 [duplicate]

Im trying to restore my database on my server, but i got the following error: The database was backed up on a server running version 12.00.2269. That version is incompatible with this server, ...
Joao Guimaraes's user avatar
0 votes
2 answers

Backup / Restore of DB on MSSQL 2019 to MSSQL 2014 [duplicate]

I have a production database running on MSSQL 2019 on a hosted platform. I am wanting to create a sandbox copy of the db with all of the data in a local MSSQL server running 2014. Everything I've ...
MattC's user avatar
  • 33
-1 votes
1 answer

Transferring Data from SQL Server to SQL Server Express? [duplicate]

How do I transfer a database from a physical server running SQL Server 2012 to another server running SQL Server 2008 Express? The database was created by sa under SQL Server 2012. Thank you.
fuzzy's user avatar
  • 1
0 votes
2 answers

migrate from sql server 2012 to sql server 2008 R2 [duplicate]

I have been looking for the information since yesterday and could not find anything... I have sharepoint 2012 fundation and my SQL Server 2010 Evaluation is short of space (we already used 10GB), ...
masber's user avatar
  • 165
0 votes
1 answer

Version error while restoring database [duplicate]

Can anybody resolve the issue where I am trying to restore a database to a SQL Server 2008 server from a backup file taken from a SQL Server 2008 R2 server?
Rakesh Vishwakarma's user avatar
0 votes
0 answers

SQL Server 2008 R2 warning when tried to execute the script of size approx 500MB [duplicate]

When I tried executing a SQL script, which was of 500MB approx. Management Studio throws an error Insufficient memory to continue the execution of the program My system memory is 8GB and only 3GB ...
l.lijith's user avatar
  • 908
0 votes
0 answers

Moving Database SQL Server 2012 to 2008/R2 [duplicate]

I'm planning to move a Large Database from SQL Server 2012 to 2008/R2. I tried the scripting thing, it works on a small-medium type of database but not on Large database w/c is about a hundred MB. Any ...
spideynok's user avatar
28 votes
4 answers

Copying (hundreds of) tables from one server to another (with SSMS)

I have several hundred (currently 466, but ever growing) tables I have to copy from one server to another. I have never had to do this before, so I'm not sure at all on how to approach it. All the ...
Der Kommissar's user avatar
11 votes
6 answers

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 ...
Lunatik's user avatar
  • 221
9 votes
4 answers

How to set 'Enable identity insert' for all the tables at once during importing data in SQL Server?

I am trying to copy a database from a remote server. I don't have access to its backups or file system. My destination database on my dev machine needs to get all the data plus the same tables ...
Tony_Henrich's user avatar
7 votes
3 answers

Rebuilding an entire Microsoft SQL Server Database

Is there a suggested way to rebuild an entire SQL Server database from another database in SQL Server 2012 SP2? Let me explain... we have a database that we are trying to enable partial containment ...
Adam Plocher's user avatar
7 votes
2 answers

How to move a fairly large tsql table from one server to another server?

I have been working on thinking of ways to move a 40gb table from one SQL Server box to another SQL Server box. They are at separate companies without an intranet linkage and obviously without linked ...
User Smith's user avatar
12 votes
2 answers

What's the best method to refresh only a few tables within a test database from production?

I have a very large production database and a very large test environment database in SQL Server 2008R2. Both databases have similar table structure but different users/logins/permissions/roles. I ...
Eric Larson's user avatar
0 votes
3 answers

Can't restore SQL Server 2016 backup to SQL Server 2014 [duplicate]

We are having an issue at trying to restore a database: System.Data.SqlClient.SqlError: The database was backed up on a server running version 13.00.4001. That version is incompatible with this ...
Rodolfo Calvo's user avatar

15 30 50 per page