Welcome to Sign in | Help

Chestie ciudata, restore si 5 secunde

  •  02-15-2007, 3:48 PM

    Chestie ciudata, restore si 5 secunde

    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

    Filed under:
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems