This IO frozen messages because of Virtual server backups. When you take a complete backup of virtual server; for consistency purpose backup software freeze the IO for few seconds. This...

hi, Can you post the scripts that you are using to restore the database.

You can definitely restore the databases that are created in SQL 2005/2008/2008 R2 to SQL Server 2012. The issues is other way around you cannot restore SQL 2012 database on...

For 30 GB no way shrink will take that long.:cool:

I suspect something is blocking the shrinking process to complete.

I would suggest check any blocking the shrink with below query..

select

t1.resource_type as...

I had a similar situation in SharePoint implementation. I have used the SQL aliasing. Create an alias refer the alias name in the code.

Please find the link below.

http://blogs.msdn.com/b/priyo/archive/2013/09/13/sql-alias-for-sharepoint.aspx

You can do number of things. I'm inline with Gail's comments, unnecessary splitting the file wont help in improving the performance.

Please consider following steps..

1.List down all the performance issues that...