I think you didnt understand my point.

Backups are taking longer with greater compression value and restores are taking smaller time.

is there a way i script out complete configuration of the server bu that way i can check whats the diffference in the configuration and settings.

when you say " _PA " it a state abbrevation, so i may need find all database which has post fix of _state, its not just " _PA"

noeld

i think that is waht i was looking but when i set there does it apply to whole sql server on that box?

when you say connection level how do i do that? do u mean session level. can i set someone to this isolation when he logs in with rdp session.

Does it mean unless i make the database READ ONLY, i can set the isolation at server level or database level??

can we set read uncommitted isolation level by default on server so that every query will use that isolation level instead of explicitly giving in the query.

1. badly configured network card can cause the drastic drop in

2. enough page file

how would i check these 2.

For step 1 as you said, I am running against the same databases from both the servers.

how wud i check step 3 and 4?

I ran this cmd

exec master.dbo.xp_cmdshell '\\DbStorage\Rev\*.bak'

and gettingthis error though sql server account has full permissions on that folder

The system cannot find the path specified.

actually its a netwrok drive , am...

Here is what i do now

exec master..xp_backup_database @database = 'mydb', @filename = 'd:\backup\mydb_tlog_20080828.bkl', @init = 1

which overwrites the existing backup file and if i use @init = 2 it will...

Guys.. any idea for troubleshooting this problem.

yes there was some processing running and the reboot was done according to our shedule.

anyways if nothing much i can do i will wait to recover.

I dont see any error message or roll back information except that

Recovery of database (11) is 0% complete (approximately 79437 seconds remain). Phase 2 of 3. This is an...

Original Databse:

database_size=259318.88 MB

unallocated space=385.41 MB

reserved=259032280 KB

data=114904320 KB

index_size=143331392 KB

unused=796568 KB

After Backedup and restored on another server:

database_size=259218.88 MB

unallocated space=292.14 MB

reserved=259025392 KB

data=114904024 KB

index_size=143320576 KB

Also i would like to tell you that after the...