Checkpoints happen by those "Activities That Cause a Checkpoint" (BOL2005).

Just find a good site to refer to for backup with/without checkpoints. http://www.sqlbackuprestore.com/recoveringindividualtables.htm

Ray Mond (10/10/2008) Restoring an invididual table from a backup may not always give you the same data compared to if you had restored the entire database. See here...

Check this post. Hope it helps.

http://www.sqlservercentral.com/Forums/Topic575684-5-1.aspx

The duties seem to be DBA routine/regular tasks. It is nice to list them out and have the problems/changes tracked and documented. A very good and detailed list.

Just...

Thank you David for sharing. This is a good learning for me.

Karl Klingler (10/13/2008)

---

Hi,

the compression rate for the first db is 1:3, for the second db it's 1:2.

Perhaps the problem lies in the data - and litespeed needs a lot of...

Found out. Instance Configuration --> "LiteSpeed 2005 extended stored procedure installation" does the job.

Some code may be useful here:

http://www.dba-sybase.com/case_study_7.php

Thank you all for your response.

I am planning to have a workaround, like differential backup, or tape backup. The question was this is not a very big...

Getting Output from a Stored Procedure into a Table

http://www.databasejournal.com/features/mssql/article.php/3386661

or you may need this for all the tables (SQL2000/SQL2005):

http://www.sqlservercentral.com/scripts/Miscellaneous/62468/

more to add on:

naming conventions; data dictionary; record column type/length fit into 8k page properly;

Archiving and/or purging should be included at the design stage, if applicable.

I am hesitating to ask...why not using Oracle?

Ninja's_RGR'us (9/28/2008)

---

The progressive delete is quite easy and often much faster than doing a single delete with millions of rows :

SET ROWCOUNT 10000

DELETE FROM dbo.Table WHERE WhatEver

WHILE @@RowCount =...

1. when job failure, go to this step:

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'AdventureWorks Administrator', -- use your own profile

@recipients = 'danw@Adventure-Works.com; yourname@email.com;