... san vendor install technician knowledge ...

Altough most SAN vendors nowadays have their own white papers for hosting databases on their san system, many technicians just don't have a clue...

- be carefull with sysindexes, because it may have an estimate count.

- adapt your script:

e.g. like this

EXEC ('if 0 = (SELECT count(*) as rowCnt from ['+@schema+'].['+@tableName +']) drop table...

Brad M. McGehee (6/26/2008)

---

When I am in a "work" environment, I call myself a DBA. If I am in a "non-work" environment, I call myself a "computer geek." When I...

you don't. 😉

- Use datatime datatype for date or time or datetime columns.

This way you are sure valid dates are entered, and you have a bunch of datetime related...

it should be ok, as long as they fix the issues that are detected.

1) read BOL. it has very good info regarding how transaction logs work and how to backup.

2) backup log

BACKUP LOG [yourdb] TO [yourdbLogBUDevice]

WITH NOINIT , --...

We use this:

With every backup job, we create backups to local drives (san or not), if available to a separated drive (non-data-files, non-log-files).

The last step of every backup job copies...

Just to add to Gails remark:

this is stated in BOL topic: "alter database"

TORN_PAGE_DETECTION { ON | OFF }

ON

Incomplete pages can be detected by the Database Engine.

OFF

Incomplete pages cannot be detected...

that's probably the best way to be sure your configuration meets at least your initial goals.

And as always, if it doesn't make sence for you, check your preception to the...

AndyD (6/24/2008)

---

...

I think this is normal operation for a Database Mirror without Witness. Have a read of "Forced Service (with Possible Data Loss)" in BOL. When the old Principal (instance01)...

just as easy...

the...

then TornPageDetection is not enabled

I suggest you enable it or have it enabled as soon as you performed a checkdb and address all issues that may appear.

use sp_helpdb !

e.g.

exec sp_helpdb 'DDBAStatistics'

result:

status (added linefeeds to narrow the linesize)

-------------------------------

Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER,

Recovery=FULL, Version=611, Collation=SQL_Latin1_General_CP1_CI_AS,

SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics,

IsAutoUpdateStatistics

If you find IsTornPageDetectionEnabled then it's ok.

You'll have to test it if suites your purpose because it is language dependant !

declare @tmptest table (idnr int not null identity(1,1) primary key, LName varchar(50) not null )

insert into...

did you try to split the "UNION ALL"

So to rewrite the full query using the TT table

and then perform a union all using the full query with the ArchTT...