Thanks Phil but this question is for people who are not that busy so they can take their time and look at the code? If my question isn't clear then...

That query worked fine. That user was looking in the wrong server. Don't you just love that?:-)

Michael L John (9/6/2016)

---

Chitown (9/6/2016)

---

All, I granted user to see all SPs in all DBs but he is not able to see any. Am I missing any steps?

This is what...

Yes, we do take full backups for dev servers every week and full, dif and tlog for Prod. We also have 6 months of backups for prod in place just...

We are going to upgrade it next week but developers need the data now to test. I am sure that's not new.

Thanks!

Thanks! Didn't think about that. Its running now.

Thanks for the reply. I appreciate that.

When I run the select * from the table, it returns 100K records in 6 minutes. I deleted top 10 records and it took almost 50 seconds (5 seconds per...

I get this Msg 208, Level 16, State 1, Line 1

Invalid...

There was another file .ndf close to 78 Gb in size which I completely forgot about. Didn't even notice it.

The validation report didn't come clean. There are some network related issues we are experiencing. For time being, I have deleted Always ON. (T logs backup are in place every...

All DBs are online and in sync

This was the error in the log file

AlwaysOn:...

Eirikur Eiriksson (6/9/2016)

---

Chitown (6/9/2016)

---

All, wondering if I can get some help? I am trying to find a script which can help me accomplish this task. I am trying to have...

GilaMonster (6/9/2016)

---

I foresee failed backups and other maintenance tasks in your future, possibly heavier server load as reports are run again and again as they keep failing, and irate users....

Finally resolved. Missing some double, triple quotations....

Select

'RESTORE DATABASE ['+name+'] FROM DISK = N''\\dd-database\database\SQL\prod\'+name+'.bak'' WITH FILE = 1, MOVE N'''+name+''' TO N''D:\Program Files\Microsoft SQL Server\MSSQL10_50\MSSQL\DATA\'+name+'.mdf'', MOVE...