For T-log check the size of your log backup file for 4 hrs. if it's big than increase the frequency of T-log backup to 1 hr.

Now the advantages of 30...

Check the new feature of SQL Server Snapshot Isolation; if that can help.

In addtiontion to Gail & Steve;

Shrink database is resource consuming hence use cautiously on the production server.

Major difference is Cost; Cluster is expensive as it require identical hardware and expensive storeage SAN/SCSI.

Mirror is configured on database level while Cluster is set up on Instance/Server level.

If your...

Oops.... 😛 by mistake wrong link has been posted:

here is correct one:-

http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html

It's purely depend on how application is design and what kind of activity is running on the server.

Check the following link for more detail:

http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=yazjum55xw4k3y55heaxpc45

Hope this will help.

You can use profiler and put filter on perticular Object on which you would like to monitor activity.

Hope this will help.

Cheers!!!

CREATE stored procedure for DBCC CHECKDB and export the output of result to the text file. You can use other than sql server programme to read the error from the...

Just check Distributed Transaction (MS DTC) can help you. You can also look topic two-phase commit (2PC).

MODEL database is used for Templet.

When the user will create the new database it will use the templet of MODEL database to create new database and all setting will be...

Make sure user is there is master database and execute following command. Replace login with user_name without quote.

use master

go

grant exec on xp_cmdshell to user_name

go

Hope this is what you are looking...

C2 auditing is resource consuming as it's capturing all the database activity hence need to use only when high security is concern.

As per your environment you need to set the parameters of sp_configure. In case if you are not sure use the default settings. Refer BOL and microsoft sites for more...

While running backup execute sp_who2 active for any blocking and deeply monitor server activity from which you may get some clue. Also check sql server and window error log if...

SSIS might be expensive. Here is the simple way; create job and write following T-SQL command:

xp_cmdshell "copy c:\myfolder\myfile.txt d:\yourfolder\yourfile.txt"