Error: Only user processes can be killed. Failed to login to SQL Server
The database being restored is the default database for the SQL Server Service account.
WORKAROUND:
Restore the database from command line.
Command line syntax may be easily generated by using the "show_cmd" syntax.
This:
execmaster.dbo.xp_backup_database show_cmd
,@database =Northwind
,@filename = 'D:Backup\2005\Northwind.bak'
, @backupname = 'Master'
, @desc = 'Backup of Master'
, @logging = 0
, @init=1
Turns into this:
F:\LiteSpeed\6.5.0.1388\Engine\SQLLitespeedx32.exe -L 0 -B "Database" -D "Northwind" -F "D:Backup\Northwind.bak" -n "Master" -d "Backup of Master" -I "1" -S "ALV99999\instance_name"
