Script de restauration automatique de DB non fonctionnel
Bonjour
Le message d'erreur est :
Citation:
ALTER DATABASE is not permitted while a database is in the Restoring state
Le script est lancé automatiquement via un ordonnanceur !
Code:
1 2 3 4 5 6 7 8 9 10 11 12
|
USE [master]
ALTER DATABASE [Pprod] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [Pprod]
FROM DISK = N'\\dcvm01\partage\PProd 02.bak'
WITH RESTRICTED_USER,
FILE = 1,
MOVE N'Neo' TO N'F:\Microsoft SQL Server\MSSQL11.TMA\MSSQL\Data\Pprod_Data.MDF',
MOVE N'ftrow_Neo_Index' TO N'F:\Microsoft SQL Server\MSSQL11.TMA\MSSQL\Data\Pprod_index',
MOVE N'Neo_log' TO N'G:\Microsoft SQL Server\MSSQL11.TMA\MSSQL\Data\Pprod_Log.LDF',
NOUNLOAD, REPLACE, STATS = 5
ALTER DATABASE [Pprod] SET MULTI_USER |