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

Does the database have "torn page detection" ON ?

I would start with a dbcc checkdb !

I'd suggest to make the primary key NONclustered !

Choose a clustered index that suites your usage ! and is as narrow as possible, preferable unique.

Keep in mind the clustered...

... schedule jobs ... ??

- Predefined jobs ?

- their own jobs or also jobs of other users ,

- what to the jobs do ?

* exec a sproc

...