The main server ( the one I backed up the database ) is :
Microsoft SQL Server 2014 - 12.0.4100.1 (X64)
Apr 20 2015 17:29:27 Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.3 (Build 9600: )
I'm trying to restore the database in this server:
Microsoft SQL Server 2014 (RTM-CU14) (KB3158271) - 12.0.2569.0 (X64) May 27 2016 15:06:08 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 (Build 10586: )
But the restore never completes. using
SP_WHOISACTIVE the complete_percentage is null ( for like, 10 minutes ).
In my own machine, I could restore the database, this is my server:
Microsoft SQL Server 2014 (SP1-CU7) (KB3162659) - 12.0.4459.0 (X64) May 27 2016 15:33:17 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 (Build 10586: ) (Hypervisor)
What can cause this problem? the database is 140GB. Is there a place where I should verify?
verifyonly the file is valid.
I'm using T-SQL to the restore:
restore database GDL_IML_TESTE from disk ='F:\GDL_IML__29072016.BKP' with move 'SPTCIML' to 'E:\gdlimlTeste\SPTCIML.mdf', move 'SPTCIMLFILES' to 'E:\gdlimlTeste\SPTCIMLFILES.ndf', move 'ftrow_GDL_IML_FULLTEXT' to 'E:\gdlimlTeste\ftrow_GDL_IML_FULLTEXT', move 'SPTCIML_log' to 'E:\gdlimlTeste\SPTCIML_log',stats=1
One thing that I noticed was the wait type
Is there a way to verify if the disk has a problem, but via SQL SERVER?
Oh, and when I pause the script, I got this message:
Msg 3122, Level 16, State 1, Line 4 File initialization failed.
RESTORE cannot continue. Msg 3204, Level 16, State 1, Line 4 The
backup or restore was aborted. Msg 3013, Level 16, State 1, Line 4
RESTORE DATABASE is terminating abnormally. Query was cancelled by