Users: 15,000+ | Page Views: 50,000+ | PPS: 2.5
TechDevOps.com
Explore Tools
{Experts in Microsoft SQL Server Operations, Performance, HA/DR, Data Migrations & Cloud Computing}



RESTORE DATABASE is terminating abnormally using Azure Blog Storage
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
2016-01-04







We had a Production Microsoft SQL Server in our Primary Data Center performing a backup of our main database to
Azure Blog Storage Container. The backup operation completed successfully, however the restore operation in Azure
was failing with the below error message:

Msg 3013, Level 16, State 1, Line 3
RESTORE DATABASE is terminating abnormally.


Solution:

Change the Microsoft Azure Virtual Machine services for service names: SQL Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER),
and set the Log On account to be the username & password that is the Administrator of the machine. Once that is set, execute
the restore from URL again and it will complete successfully assuming no other issues.

5 percent processed.
10 percent processed.
15 percent processed.
20 percent processed.
25 percent processed.
30 percent processed.
35 percent processed.
40 percent processed.
45 percent processed.
50 percent processed.
55 percent processed.
60 percent processed.
65 percent processed.
70 percent processed.
75 percent processed.
80 percent processed.
85 percent processed.
90 percent processed.
95 percent processed.
100 percent processed.
Processed 1840424 pages for database '', file '' on file 1.
Processed 20 pages for database '', file '' on file 1.
RESTORE DATABASE successfully processed 1840444 pages in 500.133 seconds (28.749 MB/sec).