Am dat de postul asta pe alt forum si in esenta zice ca dupa ce face un restore trebuie sa astepte 5 secunde inainte de a reusi sa se conecteze...
Ciudat...
Cam astea sint datele problemei (sint posibile typo la transcriere):
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_restor]
@numedb nvarchar(50),
@backuppath nvarchar(250)
AS
BEGIN
DECLARE @strSQL NVARCHAR(1000)
SET @strSQL = N'ALTER DATABASE ' + @numedb+ ' SET SINGLE_USER WITH
ROLLBACK IMMEDIATE'
EXEC sp_executesql @strSQL
RESTORE DATABASE @numedb FROM DISK = @backuppath
SET @strSQL = N'ALTER DATABASE ' + @numedb + ' SET MULTI_USER WITH ROLLBACK
IMMEDIATE'
EXEC sp_executesql @strSQL
END
Daca se deschide conexiunea imediat eroarea e:
[DDNETLIB][ConnectionWrite (WrapperWrite()).]General network error.....
Dupa 5 secunde merge bine