Have you looked at upgrading? Compressed backups may help you.

[Unfortunately, the sql server is SQL 2005...so no compressed bkp possible..]

More work, but you could also try spreading you index rebuilds...

Many Thanks

Thanks Anthony.

However, found one MS post technet article (http://msdn.microsoft.com/en-us/library/ms151196.aspx), which says through P2P Replication we can implement the similar feature..

Is this meaningful?

Regards.

Very Nice Question...

Thanks Guys...It works!

Not a bad question .. !

Thanks GilaMonster, the server is SQL 2K8.

I'm now suggesting the customer to use 'database level encryption'.

Thanks guys for the valuable feedback.

The results will depend upon the presence of the database - test2!!

I knew that unless we allocate a specific amount of max server memory, SQL will try to capture the most if required and OS will suffer to get the requisite...

Hi Gail,

I wanted to know how much will be proportion while setting SQL Server memory (Min and Max server memory configuration). Also, the SQL Server, where the MOSS and Biz...

Database Shrink job doesn't run during the time of Rebuild Of the Indexes. The strategy is:

1. First the Database Bkp job runs.

2. Second the T-Log bkp job is kept stopped...

You can also check in the 'sys.dm_exec_sessions' view to get the details against the 'session_id' which is the SPID in the sysprocesses table!

Thanks Gail.

So, are you suggesting me to use 'the database maintenance task' to rebuild the stats?