Hi, Thanks for both of your replies.

I have fixed the issue by doing couple of more log backups then I shrank and it worked.

arnipetursson, However, I am curious to...

sqlfriends (1/22/2013)

---

MyDoggieJessie (1/22/2013)

---

When you right click and view the DB size it includes the log file and is a rounded number (which you know). The space shown in the...

zi (1/11/2013)

---

Thank you very much, I got it mostly

If I want to stop restoring at a certain log file. what should I do to finish

what I mean is to change...

Thank you. I will read through the tempDB whitepaper article.

SueTons.

Great, Thanks again.

SueTons.

Anthony, What exactly am I looking here(sys.sql_modules).

SueTons.

Thanks Anthony....appreciate your quick response.

SueTons.

anthony.green (1/10/2013)

---

Any references to that table will break once the name is changed, so things like views, functions, procedures etc will need checking to see if they reference the table...

imani_technology (1/9/2013)

---

Please forgive my ignorance. I am more of a BI developer than a DBA. Is there a way to determine when users logged into a specific SQL...

alexandert680@gmail.com1/9/2013)[/b]

---

Post the exact errors from the SQL error log (all of them), then switch the DB into Emergency mode and run

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

and post those...

Thanks Jason. Will look into it.

SueTons.

Thanks, I did that.

I ran dbcc chekcdb(dbname)....and looked at the error, I see an error 'An error occurred in the service broker manager, error:823, state 2.

I also see another error...

Hi All,

I just want to update you guys with the results.

I could not RDP directly to the server due to firewall issue.

So, there was a jump server(terminal server)....which I need...

Craig,

The best way to go about it is to find the SLA/RTO and create a backup plan based on it. For example if your SLA requirement is for 2...

Ok...Thanks Gail.

SueTons.