Looks like corrupt system files for me.

You might want to run the setup.exe for SQL 2012 and try to repair the instance.

I think, TempDB checkpointing occurs at 70%.

You can also try manually running the Checkpoint several times on TempDB and see if that helps.

If it still doesnt help, I suppose...

Have you tried registering the SPN?

My Suggestion would be to use Table Partitioning instead of new DB creation every year.

For Altering Database Properties, I reckon you would require a Server level ALTER privileges.

Being DB_Owner would not be sufficient.

Grant Fritchey (10/23/2014)

---

vincyf1 (10/23/2014)

---

Database Restore - When a DB...

Database Restore - When a DB Backup is restored...

I would recommend LiteSpeed for SQL Server for Backup and Recovery.

Tried and Tested to be one of the Best. 🙂

One other option which I had used was -

1. Perform Backups (Weekly Full, Daily Differential, 4-hourly Log)

2. Write a script that runs every 4 hours (30 minutes after Log Backups)...

halifaxdal (10/16/2014)

---

GilaMonster (10/16/2014)

---

Developer edition is the equivalent of Enterprise edition in terms of features, but it is licensed for non-production usage only. You may not use it for production systems...

Great question! Thank You!

For someone who wants to achieve a MCM Certification one day, this news has killed the sole purpose of their goal! :angry:

Can someone tell microsoft that many are not happy...

All - Thanks so much 🙂