Gila - Could you point me to some good sites for advanced Performing Tuning scripts?

Thanks.

This thread might answer your question.

http://dba.stackexchange.com/questions/47108/alwayson-ag-dtc-with-failover

Here you go.

https://technet.microsoft.com/en-us/library/ms143393(v=sql.110).aspx

Upgrade Process - SQL 2012

https://msdn.microsoft.com/en-us/library/cc707783(v=sql.110).aspx

http://www.sqlskills.com/blogs/paul/correctly-adding-data-files-tempdb/

With the native maintenance plan, if someone creates a new database without taking a FULL backup, then your TLog backup job will fail. It may not be the case here...

Sorry I meant to say BEFORE the Full backup.

Go to SQL server configuration manager and see what account SQL is using as that account may not have permission to access the folder where your mdf files are in....

Nevertheless, if you are able to see your mdf files then follow this link to attach them back. I assume that you are familiar with SQL server management studio.

Mdb is a MS Access file extension, not SQL server. Perhaps try using MS access and see if you can open them.

Mdb is a MS Access file extension, not SQL server. Perhaps try using MS access and see if you can open them.

Do you still have a backup of the database? If you placed your Data and Log files to a non default path during the setup, then you could attach them...

Doing an index maintenance right after the FULL could reduce the size of the Diff backup.

Did you try reinstall SQL server from scratch?

I had done something similar but to validate the backups. Here are the steps that I used.

1. Share PROD backup folder so that you can access it on TEST.

2. Use...

I recommend using the Ola Hallengren's SQL maintenance solution as it is very robust and will let you configure when to reorg or rebuild indexes. I believe the script will...