We have mirroring on another server and a snapshot as part of high availability. Snapshot is taken every 12 hours. But snapshot takes more physical reads than the production database....

Pls find my reply..

Does the report have to run during business hours? - Yes

Can the report be scheduled to run outside of hours? - No, because the end users...

how is it different from Ctrl+F5 which does the same parsing as NOEXEC does?? pls correct me if am wrong.

If you these two sentences in the report, the number of rows differ by huge margin. Actually the number of rows in second line is the correct one. My question...

Yes Adi!! it was perfect!! thank you for your worthy contribution..

as early as possible.. since its EOD today we have 12+ hrs 🙂

I have come up till this.. here I have hard coded the values of i. if this result is arrived dynamically or looping using any other logic it will be...

I copied the file from other part of the world using TeraCopy.exe. Though the file size in bytes is same, the SQL command says its incomplete. Need to find other...

Hi all.. sorry for the inconvenience.. the backup file is been corrupted. just find using Restore Headeronly..

thanks!!

Msg 3241, Level 16, State 13, Line 1

The media family on device 'F:\DB backup\backup_2014_03_07_220436_4816312.bak' is incorrectly formed. SQL Server cannot process this media family.

Msg 3013, Level 16, State 1, Line...

here it is..

am not able select the backup file.. pls check the attached screeshot.

its not any of the system database.. its one of the user database

Oh Yes.. the auto close on option was enabled and hence those doubts.. I have made it false now and my doubt is cleared.. somebody created with those options ON.

Thanks...

I am logging as sa

Also I found if I am running "use database", that particular database, the value of is_cleanly_shutdown becomes 1

And those databases are not showing up when I...