Perform this on your backup file to ensure it is valid:

RESTORE VERIFYONLY FROM DISK = 'D:\MSSQL_BACKUP\DB_backup_201201221250.trn' WITH STATS = 1

If the result comes as...

Thanks for the reply Ashish. I understand when we install the Service...

Guys , please anyone , who has done this in past :cool:!!

Thanks Gail for providing the answer. I have been assigned to a new project where I saw this kind of memory configuration on one server. It was very surprising for...

Are you saying you uploaded the .mdf files to the IIS ?? That doesn't...

Dan Guzman-481633 (1/18/2012)

---

Hi, Sujeet.

Sorry for the confusion but I'm in the process of making some last minute changes to Level 7 of this Stairway. My day job sometimes gets...

carmellabanker (1/19/2012)

---

SQL Server Enterprise Manager allows for enterprise-wide configuration and management of SQL Server and SQL Server objects. SQL Server Enterprise Manager provides a powerful scheduling engine, administrative alert capabilities,...

Thanks for the replies folks! One more question is, what about the shared components ? Should I update them too if I am installing the Service Pack for just one...

Hey Dan,

I...

george.pancescu (1/16/2012)

---

What still bothers me is the fact that the CPU even at its normal traffic conditions, it is around 70-80%; we tried optimizing procedures based on how often they...

This very good script is available on msdn itself to identify & rebuild/reorganize indexes based on the fragmentation level. You can use the same.

-- Ensure a USE <databasename> statement has...

May be you have mistakenly tried to insert the same row on both servers. i.e. you have inserted the row on...

george.pancescu (1/16/2012)

---

I am not sure...

george.pancescu (1/16/2012)

---

Thank you for your quick response!

I will remove the "update stats" statement; regarding the job schedule, we used to have it on Saturday at 3AM, but what made...

Please provide some information about the hardware of the server also.

As a guideline:

1. Rebuild the index only in the off hours (in the night or whatever is appropriate)

2. Since you...