How is your replication topology layout?

who is subcribed to waht and do you have some subcribers who are also publishers?

Hi,

What are the chances that the replicatin may not be applying due to reasons such as the Publisher tables not having any new records to replicate to the subscriber?

I...

Thank you all.

Truncate is not logged so i would assume it being faster!

My question is how often should one reorganize indexes? daily, weekly or monthly or just on demand?

Also enable backup verification before overriding yesterday's backup.

hi,

i know this may sound stupit to ask, but how will you retrieve audit data from this?

You can use sp_configure to adjust your SQL memory with PAE enabled.

Depending on the OS platform and edition you are using, it's possible to use more RAM for SQL by enabling PAE and using AWE.

visit:

http://forums.techarena.in/tips-tweaks/979404.htm

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

My login auditing setting is set to audit failed login.

No,

i do not have.

Thanks.

hi,

Let's exclude db backup.

Hi,

According to the customer the Database was working before +- 24-48 hours ago.

There is another instance on the erver running but i have no access to that instance.

Microsoft forefront is...

Date8/16/2011 12:24:45 PM

LogSQL Server (Archive #2 - 8/17/2011 7:43:00 PM)

Sourcespid147

Message

FCB::Open failed: Could not open file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\bdname.mdf for file number 1. OS error: 32(The process cannot access...