Do you have a good backup of the affected database?

EAS-917374 (12/23/2011)

---

I think you are making my point for me. If I partition by date, then I only get the benefit of partition elimination when I query using a...

Check TLOG BACKUP script - it should include a "TO DISK=N'----location of the tlog trn files----' option.

angel.fernandezj (12/27/2011)

---

Hi everyone, I was asked to script or backup all the security of a SQL server with multiples databases. I have to script: SQL server users, database logins, roles...

Cross post - please answer here: http://www.sqlservercentral.com/Forums/Topic1227037-392-1.aspx

bill.akin (12/27/2011)

---

I have restored my live database into my test dbase with norecovery so that i can get to my transaction logs to restore at a point in time. ...

mrecuerop (12/27/2011)

---

Hi, thanks for your answer.

No, it's not a test nor homework, it's just a doubt about how could i get some data.

I think that my poor english doesnt make...

erwinluke (12/24/2011)

---

Many ways are present to move or copy a database from one server to another server using SQL server tools. Even so, as my experience the best way is...

Okay... install...

EAS-917374 (12/19/2011)

---

There is an advantage to partitioned views which in my opinion is frequently overlooked, and that is the ability to specify multiple "partition keys", by adding multiple constraints to...

Wondering why you got all your posts blanked out - ashamed of them?

logicinside22 (12/22/2011)

---

I want to learn T-SQL Programming but don't know from where to get starts ?

so if you send me some advices ,guidenece or work flow ...

This is pretty straight forward.

As you may be aware of some...

Dev (12/20/2011)

---

PaulB-TheOneAndOnly (12/20/2011)

---

Dev (12/20/2011)

---

At the end of the day, if business is asking for granular data or for an aggregation nobody thought before there is little...

Elliott Whitlow (12/20/2011)

---

Although the phrase Materialized views is not used often with MS SQL the Indexed views are the equivalent. As they must be materialized and stored very much...