Its not necessary.

Keep in mind that when you create foreign keys, an index is not automatically created at the same time. If you ever plan to join a table to...

Check http://support.microsoft.com/?kbid=902388

HTH!

MJ

Try checking the 'Schema Changes History' report for that database. It might be having the information you are looking for. Its same as checking default trace output.

Manu

Consider watching these two counters: SQLServer:Memory Manager: Total Server Memory (KB) and SQLServer:Memory Manager: Target Server Memory (KB). The first counter, SQLServer:Memory Manager: Total Server Memory (KB), tells you how...

Run under master database on secodary server:

sp_help_log_shipping_monitor_secondary

@secondary_server = 'secservername',

@secondary_database =secondarydatabase

sp_help_log_shipping_secondary_database @secondary_database ='secondarydbname', @secondary_ID = 'outputfromabovequery'

MJ

You can detach the model and the msdb database (with trace flag 3608 (-T3608) but you shouldn't even try it as it won't allow you to attach again.

See: http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/13428/sql-dont-start-after-detach-model-and-msdb

MJ

What versions of .net are installed on the system?

MJ

Seems to be a permission issue

MJ

First verify the "Distribute Transaction Coordinator" Service is

running on both database server computer and client computers

1. Go to "Administrative Tools > Services"

2. ...

Better reduce the max server memory limit.

http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

MJ

I was just trying to show him how "online piecemeal restore" works. I agree with Steve that mirroring can be a good option here.

MJ

On Server1:

Created a test database with PRIMARY and user filegroup.

CREATE Database TestFG

ON PRIMARY

(Name=TestData

,Filename='C:\SQL2008\Data\TestData.mdf'

)

,FILEGROUP TestFG

(Name=TestData_FG

,Filename='C:\SQL2008\Data\TestData_FG.ndf'

)

LOG ON

(Name=TestLog

,Filename='C:\SQL2008\Data\TestLog.ldf'

);

Took backup of the empty database.

BACKUP DATABASE TestFG

TO DISK='C:\SQL2008\Backup\TestFg.Bak'

Take transactional backup.

BACKUP LOG TestFG TO DISK= 'C:\SQL2008\Backup\TestFg.bak'

Server...

Aren't they getting deleted by ghost-row cleanup thread?

http://support.microsoft.com/kb/932115

MJ

Could not find an entry for table or index with partition ID %I64d in database %d. This error can occur if a stored procedure references a dropped table, or metadata...

Better turn it ON unless you see performance degradation due to update stats running on server during peak hours.

http://blogs.msdn.com/ianjo/archive/2005/11/10/491549.aspx

MJ