You can also explore few tools available to read sql server log files (.ldf). One of them is log explorer.

http://www.lumigent.com/products/le_sql.html

Thanks

Sachin

Hi,

Check this url below.

http://www.sql-server-performance.com/sql_server_profiler_tips.asp

The above article will help you to understand the events you should add.

BOL= Books online. Its the SQL server help files.

Thanks,

Sachin

Hi Brandie,

Nice article and thanks a lot to clarify the rumors.

I have a question. I am MCP. Cleared one exam(70-228) from MCDBA sylabus. Can I upgrade to MCITP? I mean...

I think it will access UNC path only if the SQL Server & SQL server Agent are running under a domain account.

Sachin

Do have SQL logshipping configured?

You might get this error while the primary server is trying to apply transaction log to the secondary server.

Also try to execute SQLDIAG utility to find...

Hello there,

This can easily be done using DTS. Check for DTS in books online. Create a package and execute the dts package using DTSrun.

Thanks

Sachin

Mark,

Which Edition of SQL server 2005, you have upgraded to?

Regards

Sachin

Mark,

On clicking Surface area configuration link, a small window appears with the following links

1) Surface Area configuration for Service and connections.

2) Surface Area configuration for features.

Seems like you clicking only on...

Hi Mark,

Surface area never displays your database. But the services installed on your box. It provides interface for enabling or disabling many Database Engine, Analysis Services, and Reporting Services features....