Time to do some studying. Haven't done any migrations in a while.

Looks like I got budget approval for SQL 2016 !!

Can I restore SQL 2005 Master, model, msdb databases to 2016 ?

https://msdn.microsoft.com/en-us/library/ms190679.aspx

Or are there other considerations since 2005 is so old...

One thought. Is there any SQL 2005 syntax or other features that will fail on SQL 2016 ??

For instance, we have some tables with datatype TEXT, which I think is...

We are migrating to VM servers at a hosting facility, away from old hardware in our own rack.

Thanks for all the helpful replies !

🙂

Doesn't cost any money ?? $10,000 to upgrade...

Can I install SQL 2016 on a new server, and just restore 2005 databases to it ??

andrew gothard (10/17/2016)

---

Firstly, if you do your backup with the checksum option, this will identify various forms of potential corruption. Restore with verifyonly will also identify a range of...

RTaylor2208 (9/30/2016)

---

edited for accuracy.

homebrew01 (9/30/2016)

---

RTaylor2208 (9/30/2016)

---

How about combine all your data at the source and then replicate it to the subscriber using an indexed view as an alternative?

When replicating an...

RTaylor2208 (9/30/2016)

---

How about combine all your data at the source and then replicate it to the subscriber using an indexed view as an alternative?

When replicating an indexed view it will...

No testing yet. I have a test server to experiment on.

They will probably be on the same server, but different databases.

The thinking was a denormalized flat file, with indexed columns would give fast search results.

Insert/Update triggers on the base tables,...

Why do you need the DB off line ?

I was suggesting searching jobs and stored procedures for anything related to backup/restore history tables.

John Mitchell-245523 (9/13/2016)

---

I notice this is an old thread, but in case anyone reading it is in a similar position, the steps are much simpler than those recommended above:

(1) Take...

Something deleting backup history for that backup ?

For instance, if you drop a database through the GUI, there's a checkbox default to delete backup history. If someone scripted out the...