Browse by Tags

Recover a database with no transaction log file - SQL Server 2005!

Published 11 November 8 1:16 AM | SqlServer-QA.net

Have you ever been in a situation that one of the database has been giving hard time! It may be the times that every DBA might go through this path without realising the root cause of the issue. The issue could be out of space on the drive where that...

Filed under: sql server, ssms, error log, suspect, 2005, corrupted, detach, attach, dataabase

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