Tail-log backup

A tail-log backup is a transaction log backup that includes the portion of the log that has not previously been backed up (known as the active portion of the...

I see both windows and sql logins under database owner option. Mine is SP4.

Might be the destination instance is not having any windows logins defined over there.

MJ

Check-->http://www.sqlvillage.com/View%20Disk%20Space%20utilization%20for%20your%20Server.htm

HTH!

There are few tables named '%logshipping_monitor%' tables in msdb tht you need to check for duplicate entry.

MJ

Do include a check wherein only indexes with more than 1000 pages are considered for index defrag or reindex.

MJ

Any solution or trick for this?

MJ

Same error with Create Database for Attach too.

The log was not rebuilt because there is more than one log file.

Msg 1813, Level 16, State 2, Line 1

Could not open new...

In 2005 also it doesnt allow you to attach database with more than one log file using sp_attach_single_file_db.

MJ

2nd set of tasks are just a genralised approach to do role swapping. As its working for you and you have already follwed the steps you needn't worry.

MJ

After failing over to secondary, all the log shipping starts from secondary, is that happen automatically? Or we need to configure log shipping again from the secondary to Primary? (if...

The following restrictions also apply to tempdb:

The database CHECKSUM option cannot be enabled.

http://technet.microsoft.com/en-us/library/cc966545.aspx

MJ

Was there any change done in sql service account password on any of the server involved in log shipping?

Manu

Is auto_close property turned ON for any of these databases?

MJ

When you restore a database that uses encryption features, there is only one thing you need to take care off - if the database master key (DbMK) needs a service...

I don't think its stored in any table. Is this an interview question?

MJ