Linked Questions

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

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), ...
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
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
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 ...
27
votes
4answers
7k views

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 ...
11
votes
6answers
18k 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 ...
7
votes
3answers
3k views

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 ...
7
votes
2answers
7k views

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 ...
12
votes
2answers
8k views

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 ...
4
votes
4answers
4k views

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

Attached database to SQL Server 2016 and now won't work in SQL Server 2014

I have a SQL Server 2014 database (on a portable hard drive) which I had to attach to a SQL Server 2016 machine using the normal attach method. However, since attaching it to that computer, it no ...
2
votes
2answers
7k views

Restoring database between different version of SQL Server (SoftwareVersionBuild)

i have a question about restoring database from newer version of SQL Server to older, when version differs only in SoftwareVersionBuild. I know that's not possible to restore database from SQL Server ...
0
votes
3answers
8k views

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

Transactional Replication to DB on Same Server instance

We have a SQL Server 2012 instance that contains a database with data for many product lines. We are looking for a way to take subsets of this data into another database on the same instance. This ...
3
votes
1answer
7k views

Downgrade database from SQL Server 2012 to 2008 [duplicate]

Hi guys got a problem with a database. I've been asked to perform some indexing and delete queries on a live database, so first of I wanted to get the database to our dev server so I can test out ...
1
vote
2answers
2k views

Move a huge databases from one SQL Server to another

I have customers databases located on my SQL Server 2008 machine. The size of these databases are around 300 GB. I would like to move them all to another SQL Server 2008. Is there a way to shrink ...
1
vote
1answer
6k views

Restore a database with compression on a non-enterprise edition SQL Server

Is it possible to restore a compressed an object from backup without the Enterprise Edition? I'm getting the following error after a RESTORE DATABASE operation. Msg 3013, Level 16, State 1, Line 2 ...
4
votes
3answers
2k views

What is the proper way to store a full table of data outside of a database? It needs to be able to be restored as well

I have a large SQL Server 2005 database that hasn't had the best maintenance over the years (I just took it over recently). There are around 100 tables that can be completely removed from the ...
3
votes
4answers
1k views

Data Migration With Different Schemas

I have a database DBv1 on a SQL Server, and I want to migrate the data in it to DBv2 (on the same box, save server). DBv2 has very similar schema. The only difference in schema is that DBv2 has one ...
2
votes
3answers
2k views

Looking for a utility to move data between databases (prod to dev) SQL Server 2012 [closed]

I am looking for an easy way to copy table data from a production SQL Server 2012 machine to a development machine (same version, level). We currently just do an export from within SSMS, but we have a ...
5
votes
1answer
957 views

What is the limit on the number of INSERT statements you can paste into SSMS and run?

I am currently creating a stored procedure that populates a table with a list of insert statements so that my DBAs can export the contents of the table to a text file and then paste the statements ...
1
vote
1answer
3k views

Import data from one Database to another script

As part of a data migration I would like to script a data transfer from the existing to a new database. I used to do this with DTS on older versions of MS SQL. I am currently using SQL 2012. Note the ...
2
votes
2answers
1k views

Scripting all of available databases to .sql files containing schema+data+users with single command

I have a SQL 2008 Express with 80 databases in it. I want to move these databases completely to another server which is hosting a SQL 2008R2 Enterprise instance. As i'm told it is better to script ...
5
votes
2answers
256 views

How can I efficiently downsize some Unicode fields?

We have a SQL Server 2012 Enterprise live transactional database that is now growing over 1G per month and is becoming a size problem for us. It is currently at 23G. Character type fields are all ...
1
vote
1answer
1k views

Sql Server: how to validate schema against a textual representation (XML or the like) natively?

I need a simple "complete dump" of the schema for our repo, in human-readable format: Sprocs, Views, the like. We need to "fix" some old schema issues that cropped in over the time, and "clean up" the ...
1
vote
2answers
1k views

Copy Specific tables from one database to another database on the same server

I have 2 databases that are identical. I make a backup of DB1 and restore as DB2. 2 days later I want to copy 5 tables from DB1 into DB2. All tables start with 'AG'. Is there a simple way of doing ...
1
vote
2answers
1k views

Migrate database from SQL Server 2008 Enterprise to SQL Server 2014 Standard

I need move database with "data compression" from SQL Server 2008 Enterprise to SQL Server 2014 Standard. But Standard edition does not support "data compression". How can I disable "data ...
2
votes
2answers
348 views

Potential issues migrating from SQL Server 2014 to 2012 by scripting tables and data?

I have a very simple question. What would be the typical "gotchas" involved with scripting all the data to migrate a 2014 SQL server database to 2012? Is this a pretty solid process? Are there ...
0
votes
3answers
1k views

Keeping an up to date copy of a SQL Server database on another server [closed]

We outsourced some of our business functions to another company. That company makes use of the same software as we do and we would like to keep a update to date copy of their database on our servers ...
0
votes
1answer
983 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 ...
1
vote
2answers
759 views

SQL Server 2008 - How to schedule a copy of view to another database?

I am a SharePoint admin and need to copy the log data in database to another temp database for analysis. The data is stored in a view ([WSS_Logging].[dbo].[RequestUsage]). There is a column [LogTime] ...
0
votes
1answer
528 views

Can I restore an SQL 2016 database mdf at an SQL 2014 Sp1 instance? [duplicate]

I have a database file .mdf created in SQL server 2016. I am planning to move at a new web hosting provider who supports 2014sp1 version. Should I proceed or this is out of specs? Can I restore an ...
1
vote
1answer
454 views

Copying Data to Other Database Tables

Should I use SSIS or stored procs to copy data from a number of database tables on one server to database tables on a different server? Each table's structure is identical to the destination server ...
1
vote
1answer
339 views

Using “Generate Scripts” with EMERGENCY/SINGLE USER mode

I am trying to create an INSERT script to salvage data from a single table in a corrupt database. I've succesfully put the database online and put it in EMERGENCY / SINGLE USER mode (following this ...
2
votes
2answers
104 views

SQL Server: migrate one table to discrete DB server

SQL Server 2012 Standard We have one table that is highly transactional (tons of inserts, no updates), that contains a BLOB object of 5kb-300kb per row. The whole table is about 31GB in size (table ...
3
votes
1answer
94 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 ...
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 ...
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=...
2
votes
1answer
121 views

Moving SQL Server 2012 Database to SQL Server 2008 R2

I follow the answer of Mr. Kin in this post How to move a database from SQL Server 2012 to SQL Server 2005 I run the query without errors, but when I check my blank database created on SQL Server ...
0
votes
2answers
118 views

SQL Server - creating a historical data backup

I've run out of space on my SQL Server 2008 Express DB. i'm creating a "duplicate" SQL Server 2008 Express DB so i can backup my data before i purge my DB so i can start over. Is there a way in SQL ...
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....
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 ...
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 ...
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 ...
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 ...
0
votes
0answers
34 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 ...