Browse by Tags

Best Practices: Upgrading Cluster SQL Server from 2000 to 2005 version - are you worried?

Published 16 November 7 4:53 AM | SSQA.net

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...

Filed under: sql server, restore, high availability, backup, security, upgrade, best practices, cluster, 2000, 2005, detach, attach, data files, logins

How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server

Published 5 October 7 7:29 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications How to move SQL Server databases to a new...

Filed under: sql server, database, kba, disaster recovery, move, detach, attach

"Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>' is invalid

Published 17 September 7 4:44 AM | SSQA.net

Got a distressed call from one of the database operators stating the error on the subject, instantly I suspect that the hardware of that server is not doing well. As the error ""Error 9003: The LSN(42:132:1) passed to log scan in database '<DBName>'...

Filed under: sql server, error, error log, hardware, log file, detach, attach, data files, 9003, mdf

Move tempdb and don't want to use Detach method!

Published 27 August 7 5:55 AM | SSQA.net

A new Developer within our testing environment asked me this question to see whether they can use DETACH/ATTACH method than using ALTER database method. For the user databases it is available such method of DETACH/ATTACH method when moving the databases...

Filed under: sql server, database, move, tempdb, detach, attach