It's not a matter of an advantage/disadvantage, it's another concept.

Clustering is a failover system for your server (not for your storage), while mirroring is a failover for your complete environment....

LDF is the logfile. A large LDF file doesn't mean it's using all the spacelog, probably there's a lot of free space in this LDF file. To check this, run:

dbcc...

And your asking if 32bit is still an option ? 😀 :D...

2 additions:

- SQLSafe has a freeware version, which does 95% of your backup tasks.

- use MSSQL2008 😀

It seems you copy the data in one transaction. If your recovery model is SIMPLE this whole transaction is registered in your logfile (needed by SQL for recovery/rollback in case...

If you query master..sysdatabases, you'll see a column called version. This column represents the internal databasestructure.

This number is higher for 2005, compared to 2000 (generally, every new MSSQL version has...

You can also look at the errorlog by executing this T-SQL statement:

exec master..xp_readerrorlog

Am I missing something? If ID is a primary / unique key it will delete 1 row...

if you run sp_who2, you'll see the SPID who is blocking.

Do a DBCC INPUTBUFFER(###)

REPLACE ### with the blocking SPID

SORT_IN_TEMPDB does what is says: Only sorts during rebuilding take place in TempDb, all other steps take place in your filegroup.

Instead of firefighting, determine what's causing the problem:

- start monitoring your databases, so you can predict diskspace issues.

- implement warnings/alerts

- make sure you backup your logfiles for full-recovery databases (common...

Check windows/sql documentation, it's pretty clear about this situation, for example see this fragment from MSSQL 2K5 CU9:

Cumulative Update 9:

Failover Cluster Installation

The following information applies only to SQL Server 2005...

Are you a salesman? 😀

Who's the lucky DBA who has this database running on this server? (I'm not)

Other question to you folks: Any experience with storing your databases on SSD...

This works only for logfiles

If you shrink a database, you'll truncate the free space at the end of a file.

Consider this datafile( X=data, .=free)

XXXXXXX.XX.....XX.......XX.XXXXXXX.XXXX............X..............

If you truncate this file, it will be something like...