The size will not reflect correctly until the trace file is rolled over or the trace is stopped.

You may try stopping and closing the trace file to see if it...

What is the error? The trace does not start at all?

Check for misspells in @FileName by printing the output of

SET @FileName = REPLACE('c:\authors_'+CONVERT(char(8),GETDATE(),1)+'.txt','/','-')

Also check if you have privileges on that file.

Can you please post the content of Summary.txt (under SetupBootstrap folder)

Maintenance clean up task is the easiest method to clean up old backup files.

These messages are part of the Dead Lock graph. Read more about Dead Lock here.

Lock pages in memory privilege is a must for AWE. Please refer this on how to grant this privilege.

You can make use of DTEXEC command line utility. An example here

Sharon,

Here you go.

Any batch file executed using xp_cmdshell will have an output of NULL. However the batch file is executed and the work is done as far as xp_cmdshell is considered. xp_cmdhshell...

DBCC OPENTRAN displays only transactions that are logged

From the error message it appears that some of the .msp files got deleted from c:\windows\installer folder and the setup is looking for those files. I had similar issue[/url] while...

Yes it is written to a network share '\\dbsrvr1a\outnow\Outnow.sqb''

For one time you can use sp_helprevlogin to sync all logins on the source to destination. After restoring the database on the destination instance, sp_change_users_login can be used to fix...

The recovery model can be set to BULK LOGGED