As per my knowledge, there is no default duration for checkpoint to happen. It happens based on certain events.

here are some excerpts from BOL.

Events That Cause Checkpoints

Before a database backup,...

The statement doesnt say it's not supported. It mentions the amount of recources utilized in BCPing out data from source and then BCPing in to the target is huge for...

You dont...

You can have a third server a monitoring server that can monitor several log shipping databases.

Alternatively you can query individual primary...

If changing a compatibility mode isn't logged operation, i dont think you can achieve what you want to without breaking the configuration/re-setting it.

sihaab (8/13/2009)

---

In other words, if I restore the db with primary file group it is already available for access, later I can restore other file groups over the primary...

sihaab (8/14/2009)

---

Steve,

I agree with you, mirroring is the good idea to setup a secondary read only database. Log shipping could be other choice but you cannot access the database while...

tikkani.praveen (8/13/2009)

---

Now after doing this activity, if i'll shrink the database i'll get 200 GB of free space. I tried shrinking files using Sql server management studio, but space was...

backup log Artesia_Prod with truncate_only will not create any file on the drive.

After running this, try shrinking the log file usind dbcc shrinkfile and see if the physical size of...

my apologies. I oversaw the error in the backup log statement.

correct code is

backup log Artesia_Prod with truncate_only

Can you run the following code on the corrputed database and post the results here. Someone will surely have a look at it and give you better ideas(if possible) than...

select convert(smalldatetime, '090803')

OUTPUT

--------

2009-08-03 00:00:00

(1 row(s) affected)

Is this what you need?

also if you paas empty string, it wont give error, instead, it'd return 1900-01-01 00:00:00

You didnot run the code i mentioned. YOu just took the snapshot of the properties of that column

I wanted u to paste the code in a query window and then...

expand your server>management>Maintainence Plan. Right click Maintainence plan and select New Maintainance Plan.

Enter the...

koustav_1982 (8/11/2009)

---

HI

I have a reporting application running from 2 different databases on 2 servers for 2 different sets of report.But both these databases need some common tables which are...