Linked Questions

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
981 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
758 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
453 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 ...

15 30 50 per page