Linked Questions

0
votes
1answer
989 views

Backup & Restore Error in MS SQL Server 2016 [duplicate]

I have a backup from SQL Server 2016. I want to restore it in my pc but I am getting this error. The database was backed up on a server running version 13.00.1400. That version is incompatible ...
0
votes
1answer
91 views

Migrate Database

I'm trying to migrate my database to another server, an older version. Currently my database is on SQL Server 2014, but I need to add migrate it to SQL Server 2012 because that's the one my server has....
0
votes
1answer
46 views

Export Wizard never starts Pre-executing

I'm using the Import/Export Wizard in SSMS 2012 to store some data into a flat file, as I have to move these data from one SQL server to another. I've tried with direct connecting to the server ...
0
votes
1answer
216 views

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?
0
votes
1answer
21k 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
0
votes
1answer
60 views

backup a specific set of tables to be moved to a remote system [duplicate]

I need to generate either backups or data dumps for about 30 tables. I want to generate a file of some sort that contains the data for these tables and transfer them to a different system. Each ...
-1
votes
1answer
1k views

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.
-2
votes
1answer
19k views

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, ...
2
votes
0answers
99 views

Techniques for moving database from Enterprise to Standard Editiion [duplicate]

I have a SQL Server 2012 Enterprise edition and a Model database. On a virtual machine I have installed SQL Server 2012 Standard Edition and want to create a copy of the Model database on it. I have ...
1
vote
0answers
37 views

How to restore hundreds of GB database present on SQL Server 2014 to SQL Server 2008 R2 [duplicate]

I know that this was not possible as a scenario for SQL Server 2012 -> 2008 but I wonder if MS made any changes here with the 2014 version. We have SQL Server 2014 version with a fairly large ...
1
vote
0answers
196 views

SQL Server 2005 CHECKCATALOG fails

CHECKCATALOG is failing on a database that originated in SQL Server 2000. I am getting errors of the type: Msg 3853, Level 16, State 1, Line 1 Attribute (object_id=489156888) of row (object_id=...
0
votes
0answers
87 views

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 ...
0
votes
0answers
35 views

Would snapshot replication avoid the “repl table shuffle” when making schema changes?

I support an application that sits upon a SQL 2008 database and has an admin tool that allows app admins to do some field customization. This issues an ALTER TABLE command when saved, and since the ...
0
votes
0answers
45 views

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 ...
0
votes
0answers
216 views

Will SQL Server 2014 not cause problems with a SQL Server 2008 DB?

I will be doing development work on a SQL Server 2008 database. I am planning on buying a copy of SQL Server for this project. I am wanting to verify that the latest SQL Server version, 2014, won't ...

15 30 50 per page