Linked Questions

Ask Question
45 questions linked to/from Upgrade SQL Server 2000 database to 2008 R2 and enable new features
Hot Newest Score Active Unanswered
2 votes
0 answers
93 views

We need to upgrade two SQL Servers for our projects to SQL Server 2012. Since we’re not db-admins or familiar with such migrations, I wanted to ask you if you could tell me what we have to be aware of ...
xeraphim's user avatar
  • 597
3 votes
0 answers
70 views

I'm looking for steps that I need to follow to transfer a database to a new server. So far I have: I restored the current database that I have in SQL Server 2005 instance to another SQL Server ...
Shayma Ahmad's user avatar
  • 655
0 votes
0 answers
39 views

I reviewed the SQL Server 2012 technical upgrade guide and also googled for more recommendations. I am migrating a SQL Server 2008 R2 instance to SQL Server 2012 on a separate machine. Here is what ...
TDPSQL_Newbie's user avatar
  • 123
75 votes
8 answers
73k views

When setting up a new SQL Server, I use the following code to determine a good starting point for the MAXDOP setting: /* This will recommend a MAXDOP setting appropriate for your machine's NUMA ...
Hannah Vernon's user avatar
  • 71.1k
12 votes
6 answers
29k views

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
  • 231
15 votes
4 answers
9k views

There are two different options in modern SQL Server for page verify; being Torn Page Detection and Checksum. None is also of course an option. I believe Checksum was introduced in SQL Server 2005 ...
Paul's user avatar
  • 1,453
6 votes
3 answers
37k views

I need to restore a SQL Server 2000 database to SQL Server 2016. Is there any possible way to do this without having to install a complete copy of SQL Server 2008, restore to 2008, change the ...
Randy Minder's user avatar
  • 2,052
9 votes
3 answers
20k views

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 ...
Robert's user avatar
  • 91
8 votes
3 answers
2k views

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 ...
BeginnerDBA's user avatar
  • 2,230
9 votes
3 answers
5k views

I need to automate the migration for some databases from an older server. I know that script a tool using C# for example can be a possibility but I need a simple, fast and effective solution in order ...
Rui Marques's user avatar
  • 315
5 votes
2 answers
10k views

We have a production SQL Server 2005 server on which we are hosting 200 databases. We want to host these databases on our new server. On new server SQL Server 2005 is installed and is ready. I want ...
Armin's user avatar
  • 177
1 vote
1 answer
13k views

I have a production environment running Windows Server 2000 and a development environment using SQL Server 2012. I need to make updates to the DB and implement some new features using .ASP. Is there ...
adam2k's user avatar
  • 113
5 votes
3 answers
14k views

Yesterday we migrated a SQL Server 2005 database to SQL Server 2012. We made a full backup and restored it on the new server. Problem now is that the database on SQL Server 2012 is much slower than ...
Guido Neele's user avatar
  • 181
5 votes
5 answers
10k views

We have a 30 GB Database on SQL Server 2008 R2 Standard Edition. Yesterday we backed up the database and restored it to a different Virtual Machine which has exactly the same specs as the previous ...
user avatar
7 votes
1 answer
4k views

I have a production server running SQL Server 2008 Web Edition, and it has to keep running 24x7 with almost no down time, and it's the time for us to move to a more advanced server hardware, also it's ...
Abed's user avatar
  • 81

15 30 50 per page
1
2 3