Jump to content

Recommended Posts

Posted (edited)

Afternoon all,

 

Migrating a SIMS DB to SQL 2014 (new server) and when running the Migration Tool on the new host the restoring part is failing with a TIMEOUT error.

The DB here is 10.8gb as a bak file, I have shrunk the log prior to performing the initial backup.

 

Anyone had any issue with migrating large DB's?

 

I'm sure this is the issue and that if the TIMEOUT was longer it would restore OK as I can restore it manually via SQL Management Studio.

 

Thoughts?

 

Cheers,

 

Andy

 

UPDATE - RESOLVED - Archived a years worth of attendance marks as well and that seems to do it... ?! Ho hum!

Edited by Tefters

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...