To fix T-log full issue during rebuild index maintenance task/ job, find out which indexes causes to Full t log file and exclude these indexes from Rebuild index maintenance plan...

for more info :

http://msdn.microsoft.com/en-us/library/ms189940.aspx

easy question

u r right, the question was not phrased very well.

not mentioned Service broker is enabled or not db1.

when we restore database from any existing DB Backup.

we always need to

1)...

some other features are ;

1. Self-service BI with Project Gemini

2. Support for 256 logical processors

3. SQL Server Express has been increased from 4 GB to 10 GB.

it truncates CustomerDocuments table

but not CustomerMaster Error Message fk ref. fired while truncating CustomerMaster.