Check the following link for Microsoft support:

http://support.microsoft.com/lifecycle/search/?sort=PN&alpha=sql

Assess the risk of continuing with old SQL Server version and communicate to the client/owner.

However it's better to check all this in test environment...

Check the system table sysjobactivity and find out if you can get what you want based on start & Stop execution date?

HTH

Not always but yes most of the time.

check following link might help...

http://stackoverflow.com/questions/13241942/what-is-spt-columns-odbc-view-and-why-is-it-not-accessible

HTH

Check this out:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8dfb2cc5-eac5-4d57-9dad-f858d3c0f0c8/is-sql-2008-compatible-with-windows-server-2012

HTH

As per the data provided everything looks OK; as only 36 MB unallocated space is reflecting out of 45 GB.

HTH

Refer following link:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/280beb43-5e43-454f-906a-d3f2f1d85926/how-to-restore-multiple-databases-from-multiple-bak-files-at-once?forum=sqltools

HTH

visit following link to troubleshoot step by step:

http://technet.microsoft.com/en-us/library/ms187540(v=sql.105).aspx

HTH

In this process no reverse gear i.e. once you failover to 2008 R2 you can't again use 2005.

Hence, advisable to take take full backup and if required log backup in...

Easy one, thanks.

You need outgoing mail server (SMTP) for Database mail.

What is the size of the database? Check the availability of downtime howmany hrs? Based on this you can check other options too like attach/detach, logshipping.

Yes, it is possible. Refer...

check following link:

http://www.techtalkz.com/windows-server-2003/39348-server-2003-restart-log.html

HTH

Good Question. Getting +2 questions continuous in a row 🙂

SQLRNNR (3/11/2014)

---

Koen Verbeeck (3/11/2014)

---

free_mascot (3/11/2014)

---

Koen Verbeeck (3/11/2014)

---

Great question.

Although the IDENTITY property doesn't always transfer:

When an existing identity column is selected into a new table, the new column inherits the IDENTITY...