Gianluca Sartori (1/23/2013)

---

Great article, Erin.

Also, lots of useful code in there.

Thanks for sharing.

ALZDBA (1/23/2013)

---

Nice article, Erin.

In my test, [vs].[logical_volume_name] is blanc !

Win2008R2 / SQL2012DE (64-bit) SP1 (11.0.3000.0) with fixed...

Nice article, Erin.

In my test, [vs].[logical_volume_name] is blanc !

Win2008R2 / SQL2012DE (64-bit) SP1 (11.0.3000.0) with fixed drives.

So I suggest altering the last query to :

SELECT DISTINCT

...

This may be one of the cases where BOL is just wrong. :angry:

This does the trick you aim for:

Create default [MinusOne] as (-1);

go

/* Syntax error near Default --> CREATE TYPE...

as you will know Tempdb is a special db, available and used by everyone in the instance.

General usage of tempdb: http://msdn.microsoft.com/en-us/library/ms190768.aspx

Great post by Gail Shaw which highlights indexing and how...

if you copy/pated the statement in your previous reply ...

you typed dfault in stead of dEfault.

Chances are you overlooked the typing error.

it will write tempdb stuff to disk all right, it's just not at checkpoint time, like with regular db.

Why: tempdb is re-created every time SQLServer is started, so there is...

did you check with books online ?

Create type:

http://msdn.microsoft.com/en-us/library/ms175007(v=sql.105).aspx

My advice: Avoid like hell because they cannot be altered when they are in use. It's not all gold that shines

IMO it should return no row at all because of the where clause condition 1 = 0

With such findings, it is best to always mention the actual engine version on which you performed the test.

Select Serverproperty('ProductVersion') as ProductVersion

, Serverproperty('ProductLevel')...

Here's a good article to help you to get to your answer: SAN Replication vs. Clustering vs. Mirroring Which should be used when? by Denny Cherry.

It also contains an interesting...

- If the time interval is near constant, just start a sqlprofiler trace to capture all the needed and analyse it afterward.

- how are the backups being created at your...

Isn't creation date and time information of the bak-file enough ?

To assemble a recovery requence, IMHO it is best to just pull all the needed data out of the msdb...

Keep in mind you cannot connect Object Browser using and admin:server\instance connection.

You must use a Query panel ( New Query ) and then connect using admin:server\instance .

Also with SQL2012, only a single active DAC is allowed !

only one DAC is allowed per instance of SQL Server. If a DAC connection is already active, any new request...

Here's a good starter article to get to your answer: SAN Replication vs. Clustering vs. Mirroring Which should be used when? by Denny Cherry.

You've posted in a SQL2005 forum. If...