Linked Questions

32
votes
1answer
67k views

How do I attach a database in SQL Server?

Some common questions relating to attaching databases in SQL Server: What does it mean to attach or detach a database? How do I detach a database? How do I attach a database? What ...
10
votes
1answer
3k views

SQL Server 2000 to 2008 to 2012

We are migrating from SQL Server 2000 to 2008 now. We are making lot of changes to code, scripts because there has been a lot of change since 2000 to 2008. While making these changes, What I want to ...
9
votes
3answers
18k views

Migrating Data from SQL Server 2005 to 2016

I am new to administering SQL Server however I am comfortable with the SQL language and making SSIS packages. I want to migrate data from SQL Server 2005 to 2016. My question is do I need to worry ...
8
votes
3answers
2k views

Risks involved in upgrading to SQL Server 2008 R2

We have quite a number of SQL Servers that need to be upgraded from version 2005 to 2008 R2. Work is planned before the middle of the year as Microsoft is ending its support for the same. The 2005 ...
8
votes
1answer
5k views

How do you move a SQL Server 7 database to SQL Server 2012?

I would like to move a database from SQL Server 7.0 to SQL Server 2012. They are not compatible for a backup and restore. Is there a way to export from SQL Server 7.0 and import it to 2012? I only ...
4
votes
2answers
133 views

SQL Server update and database transfer

In my test network there is a database created with SQL Server 2005. I have to update SQL Server 2005 to SQL Server 2008. The data base should be used with SQL Server 2008. So it is to be moved. What ...
4
votes
1answer
24k views

Migrate SQL Server from 2012 to 2014 (11 to 12)

I have just installed SQL Server Management studio 2014 and I also need to update my (local) server to accept a new database via a bak file from a version 12 server. When I look in Server Properties I ...
2
votes
1answer
25 views

What's better - setting up Always On fresh and migrating data, or using existing server with data and adding Always On?

I have an existing SQL Server instance with three databases and a small amount of data. I've been asked to create an Always On Availability Group now. The existing server would need to have the ...
2
votes
1answer
46 views

SQL Server 2012 In-Place Upgrade and Timing of Database Version Change

We are updating several SQL Server 2008R2 instances to SQL Server 2012 SP3 CU2. I know that the database versions will be changed from 100 to 110 during this process (e.g. once finished, the databases ...
2
votes
1answer
66 views

Minimise time for migration

I want to migrate production DBs from one server to a different one. This is my plan: Shut down the application Change the DB to single user mode Take a full backup for all databases Restore the ...
2
votes
1answer
2k views

Migrating reports from SSRS 2005 to SSRS 2014 and SSAS 2005 cube to SSAS 2014?

As SQL Server 2005 end of life is getting closer I'm facing inevitable job of migrating databases, SSIS packages, SSRS reports and SSAS cubes. Since newest version of SQL Server is SQL Server 2014 we ...
1
vote
1answer
934 views

SQL Server 2016 in-place upgrade time for large databases

Is there any statistics on how long it will take to in place upgrade SQL Server 2014 to SQL Server 2016 on a server with 1000+ databases and 10TB of storage? How long it will take to install ...
1
vote
3answers
992 views

Check of SQL Server upgrade success

I have performed SQL Server upgrade from 2005 to SQL Server 2008. Is there any tools/possibilities to check, whether the upgrade from SQL Server 2005 to SQL Server 2008 has been accomplished ...
1
vote
1answer
124 views

SQL Server Upgrade - A new Approach for Upgrading

Microsoft's technical guide for SQL Server upgrade references two upgrade paths: in-place and side-by-side. I don't see a third, visibly more viable/convenient option, which is to do an in-place ...
0
votes
1answer
109 views

Hazards of Upgrading SQL Server Express 2008 to R2

A client of mine reached the 4GB database limit on a SQL Server 2008 Express. As a test I installed the R2 version on another machine and restored a backup of the database. I'd like to upgrade the ...