Browse by Tags

Site sponsored by:

The gold standard of SQL Server performance monitoring & diagnostics

RSS Feeds

upgrade (RSS)

SQL Server 2008 Upgrade Technical Reference Guide Released

The SQL Server 2008 Technical Reference Guide has just been released, covering the essential steps and best practices to upgrade existing 2000 and 2005 instances to 2008. There is also a list of other upgrade resources available at http://msdn.microsoft.com/en-us/library/cc936623.aspx These guides are...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 11-26-2008
detach user dbs during sql2005 in-place upgrade

Is it best practice to detach user dbs during sql2005 IN-PLACE upgrade from sql2000? If it is, after upgrade (setup.exe) is successfully done, will re-attach the user dbs to the newly in-place upgraded server then act like the side-by-side upgrade where we restore/attach user dbs? except that we don't...

Posted to SQL Server 2005 General DBA Questions (Forum) by tchangEcast on 10-23-2008
sql 7 to 2005 migration nightmare-Please help!

We use a third party issue tracking software that uses SQL. Last November we upgraded the sql software and server. We moved the SQL 7 database to a new server running workgroup 2005. The move went fine except after a few days the tracking software started responding slowly. Rebooting the SQL server would...

Posted to SQL Server 2005 General DBA Questions (Forum) by Chrisc on 07-02-2008
SQL Server Upgrade Advisor Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

One of the client referred about the error during the execution of Upgrade Advisor: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Initial thoughts lead to checking the SQL Server timeout setting which has been left with default value...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 02-13-2008
You encounter a problem with a subscription that uses the file share delivery extension in SQL Server 2005 Reporting Services or in SQL Server 2008 Reporting Services after you upgrade Windows Server 2003 to Windows Server 2008

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete You encounter a problem with a subscription that uses the file share delivery extension in SQL Server 2005 Reporting Services...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 01-30-2008
SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb

Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgrageTags posts. Here in this post I would like to go with few FAQs that are related to Upgrade process & procedure...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 01-22-2008
All about SQL Server with 32bit to 64bit cluster migration - steps to take care

An interesting cross-post from SSP Blog - read thisblog for more information....( read more )

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 01-15-2008
All about SQL Server with 32bit to 64bit cluster migration - steps to take care

Recently there has been few 'interesting' posts that will help most of the SQL Server users in this cyber world. Here is the basic question posted by the user: I have been tasked with migrating our SQL Server 05 Active/Passive cluster from 32bit to 64bit with as little downtime as possible. What...

Posted to SQL Server Knowledge Sharing Network (SqlServer-qa.net) (Weblog) by satya on 01-14-2008
Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

I know it sounds easy to upgrade a SQL Server Cluster environment from 2000 to 2005 version, as easy it mentioned within the Books Online for SQL Server 2005. When I have performed for the first time, my first thought was (do we need that or take out the reasons). But one thing is sure that SQL Server...

Posted to Other SQL Server Blogs around the Web (Weblog) by Anonymous on 11-16-2007
Re: Migration

Backup and Restore Attach and Detach SSIS or DTS to transfer data after creating the database using scripts. But it purely depends on the ways you want to achieve, say downtime and by all means take help from Upgrade Advisor and from thsi http://sqlserver-qa.net/blogs/tools/archive/tags/upgrade/default...

Posted to Getting Started (Forum) by satya on 10-10-2007