Pb restoring MASTER database

SupportReseauGECIPSupportReseauGECIP Posts: 14
edited October 11, 2010 10:11AM in SQL Backup Previous Versions
Hello everybody,

I've builded a test platform to see how restoring Master database works. I'm connected as domain administrator on my server.

I have used the Knowlegde Base topic 'Restoring the SQL Server MASTER database' and followed all instructions.

When I try to restore with my parameters using the command line "SQLBackupc -SQL "RESTORE DATABASE [master] FROM DISK='<path to master backup>' WITH PASSWORD='<password>'" -I <instance> -U <username> -P <password>", I have errors messages :

Restoring master (database) on SQLSERVER2005 instance from:
C:\DATA\FULL_SQLSERVER2005_master_20101008_143607.sqb

SQL error -2147467259: Communication Link Failure
SQL error 233: Shared Memory Provider- No process is on the other end of the pipe.

Server : TEST-SQL\SQLSERVER2005
Windows authentication
Failed to connect to SQL Server instance: TEST-SQL\SQLSERVER2005
SQL Backup exit code: 586
Last SQL error code: 233

Thanks for your help.

Patrice.
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    Are you following the instruction here (http://www.red-gate.com/supportcenter/C ... wledgebase\SQL_Backup\KB200804000249.htm&p=SQL%20Backup)?

    From the error message, it looks like there is a problem connecting to the SQL Server instance using the command line interface. Try starting the SQL Server service normally, and test if the SQL Backup command line interface works. Youl could try something like this:
    sqlbackupc -sql "BACKUP DATABASE model TO DISK = '&lt;AUTO&gt;'"
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • SupportReseauGECIPSupportReseauGECIP Posts: 14
    Hello Pete,

    As I said, I followed all the instructions. I backup Master database thru the SQL Backup GUI interface with no problem.

    My pb is to restore this Master db. I gonna try your command line and come back to you.

    Thanks.

    Patrice.
    · Share on Twitter
  • SupportReseauGECIPSupportReseauGECIP Posts: 14
    edited October 11, 2010 4:42AM
    Hello Pete,

    I have errors because I have to insert my instance name. What is the new command lines to do this? DO I havbe to put the -I <Instance Name>?

    Thanks.

    Patrice.
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    Use the -I parameter e.g.

    sqlbackupc -sql "BACKUP DATABASE model TO DISK = '<AUTO>'" -I PROD
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • SupportReseauGECIPSupportReseauGECIP Posts: 14
    Thanks Pete,

    Backup works fine now. But when I restore I have an error message.

    I've put my server to a single mode and start to restore again.
    The steps :

    1- Stop SQL Server Instance
    2- Run in command prompt : sqlservr.exe -m -sSQLSERVER2005
    3- In a second command prompt : SQLBackupc -SQL "RESTORE DATABASE [master] FROM DISK='C:\data\master20101008.sqb>'" -I SQLSERVER2005

    I have the same error :

    SQL error -2147467259: Communication Link Failure
    SQL error 233: Shared Memory Provider- No process is on the other end of the pipe.

    Server : TEST-SQL\SQLSERVER2005
    Windows authentication
    Failed to connect to SQL Server instance: TEST-SQL\SQLSERVER2005
    SQL Backup exit code: 586
    Last SQL error code: 233

    Thansk for your help.

    Patrice.
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    Are there any errors recorded in the Windows Application Log, or the SQL Server logs?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • SupportReseauGECIPSupportReseauGECIP Posts: 14
    Log when stop SQL Server Service and put to single mode :

    2010-10-11 11:42:25.52 Server Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)
    May 26 2009 14:24:20
    Copyright (c) 1988-2005 Microsoft Corporation
    Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    2010-10-11 11:42:25.54 Server (c) 2005 Microsoft Corporation.
    2010-10-11 11:42:25.54 Server All rights reserved.
    2010-10-11 11:42:25.54 Server Server process ID is 1508.
    2010-10-11 11:42:25.54 Server Authentication mode is MIXED.
    2010-10-11 11:42:25.54 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
    2010-10-11 11:42:25.54 Server This instance of SQL Server last reported using a process ID of 2504 at 11/10/2010 11:42:14 (local) 11/10/2010 09:42:14 (UTC). This is an informational message only; no user action is required.
    2010-10-11 11:42:25.54 Server Registry startup parameters:
    2010-10-11 11:42:25.54 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
    2010-10-11 11:42:25.54 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
    2010-10-11 11:42:25.54 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
    2010-10-11 11:42:25.55 Serveur SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2010-10-11 11:42:25.55 Serveur Detected 1 CPUs. This is an informational message; no user action is required.
    2010-10-11 11:42:26.00 Serveur Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
    2010-10-11 11:42:26.08 Serveur Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
    2010-10-11 11:42:27.25 Serveur Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
    2010-10-11 11:42:27.26 Serveur Database mirroring has been enabled on this instance of SQL Server.
    2010-10-11 11:42:27.30 spid5s Starting up database 'master'.
    2010-10-11 11:42:27.56 spid5s 10 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
    2010-10-11 11:42:27.62 spid5s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
    2010-10-11 11:42:27.62 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2010-10-11 11:42:27.83 spid5s SQL Trace ID 1 was started by login "sa".
    2010-10-11 11:42:27.87 spid5s Starting up database 'mssqlsystemresource'.
    2010-10-11 11:42:27.91 spid5s The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
    2010-10-11 11:42:30.07 Serveur A self-generated certificate was successfully loaded for encryption.
    2010-10-11 11:42:30.08 spid5s Server name is 'TEST-SQL\SQLSERVER2005'. This is an informational message only. No user action is required.
    2010-10-11 11:42:30.09 Serveur Server is listening on [ 'any' <ipv4> 1163].
    2010-10-11 11:42:30.09 Serveur Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLSERVER2005 ].
    2010-10-11 11:42:30.10 Serveur Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLSERVER2005\sql\query ].
    2010-10-11 11:42:30.11 spid9s Starting up database 'model'.
    2010-10-11 11:42:30.13 Serveur Server is listening on [ 127.0.0.1 <ipv4> 1164].
    2010-10-11 11:42:30.13 Serveur Dedicated admin connection support was established for listening locally on port 1164.
    2010-10-11 11:42:30.27 Serveur SQL Server is now ready for client connections. This is an informational message; no user action is required.
    2010-10-11 11:42:30.37 spid12s Starting up database 'msdb'.
    2010-10-11 11:42:30.37 spid14s Starting up database 'sem5'.
    2010-10-11 11:42:30.37 spid15s Starting up database 'ReportServer'.
    2010-10-11 11:42:30.39 spid13s Starting up database 'Redmine'.
    2010-10-11 11:42:31.62 spid9s Clearing tempdb database.
    2010-10-11 11:42:32.12 spid15s Starting up database 'ReportServerTempDB'.
    2010-10-11 11:42:33.05 spid15s 1 transactions rolled forward in database 'ReportServerTempDB' (12). This is an informational message only. No user action is required.
    2010-10-11 11:42:33.18 spid15s 0 transactions rolled back in database 'ReportServerTempDB' (12). This is an informational message only. No user action is required.
    2010-10-11 11:42:33.18 spid15s Recovery is writing a checkpoint in database 'ReportServerTempDB' (12). This is an informational message only. No user action is required.
    2010-10-11 11:42:34.98 spid13s 1 transactions rolled forward in database 'Redmine' (5). This is an informational message only. No user action is required.
    2010-10-11 11:42:35.03 spid13s 0 transactions rolled back in database 'Redmine' (5). This is an informational message only. No user action is required.
    2010-10-11 11:42:35.03 spid13s Recovery is writing a checkpoint in database 'Redmine' (5). This is an informational message only. No user action is required.
    2010-10-11 11:42:35.68 spid9s Starting up database 'tempdb'.
    2010-10-11 11:42:36.38 spid13s The Service Broker protocol transport is disabled or not configured.
    2010-10-11 11:42:36.38 spid13s The Database Mirroring protocol transport is disabled or not configured.
    2010-10-11 11:42:36.60 spid13s Service Broker manager has started.
    2010-10-11 11:42:37.05 spid14s Analysis of database 'sem5' (9) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
    2010-10-11 11:42:37.08 spid12s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
    2010-10-11 11:42:37.24 spid14s 1 transactions rolled forward in database 'sem5' (9). This is an informational message only. No user action is required.
    2010-10-11 11:42:37.26 spid12s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
    2010-10-11 11:42:37.26 spid12s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
    2010-10-11 11:42:37.35 spid14s 0 transactions rolled back in database 'sem5' (9). This is an informational message only. No user action is required.
    2010-10-11 11:42:37.35 spid14s Recovery is writing a checkpoint in database 'sem5' (9). This is an informational message only. No user action is required.
    2010-10-11 11:42:37.80 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
    2010-10-11 11:42:37.80 spid5s Recovery is complete. This is an informational message only. No user action is required.
    2010-10-11 11:42:38.76 spid53 Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
    2010-10-11 11:42:40.23 spid53 Using 'xpsqlbot.dll' version '2005.90.4035' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
    2010-10-11 11:42:40.77 spid53 Using 'xpstar90.dll' version '2005.90.4035' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
    2010-10-11 11:42:40.86 spid53 Using 'xplog70.dll' version '2005.90.4035' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
    2010-10-11 11:42:54.97 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:42:54.97 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:43:59.99 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:43:59.99 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:45:10.49 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:45:10.49 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:46:20.56 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:46:20.56 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:47:26.58 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:47:26.58 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:48:35.95 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:48:35.95 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:49:37.66 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:49:37.66 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:50:42.56 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:50:42.56 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:51:51.37 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:51:51.37 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:53:00.84 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:53:00.84 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:54:05.87 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:54:05.87 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:55:13.39 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:55:13.39 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:56:22.67 Erreur : 18456, Gravité : 14, État : 16.
    2010-10-11 11:56:22.67 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. [CLIENT : <local machine>]
    2010-10-11 11:57:18.05 spid52 Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2010-10-11 11:57:22.78 spid13s Service Broker manager has shut down.
    2010-10-11 11:57:23.57 spid5s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.
    2010-10-11 11:57:23.57 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

    Log when restore Master :

    2010-10-11 11:57:35.38 Server Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)
    May 26 2009 14:24:20
    Copyright (c) 1988-2005 Microsoft Corporation
    Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    2010-10-11 11:57:35.40 Server (c) 2005 Microsoft Corporation.
    2010-10-11 11:57:35.42 Server All rights reserved.
    2010-10-11 11:57:35.42 Server Server process ID is 592.
    2010-10-11 11:57:35.42 Server Authentication mode is MIXED.
    2010-10-11 11:57:35.42 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
    2010-10-11 11:57:35.42 Server This instance of SQL Server last reported using a process ID of 1508 at 11/10/2010 11:57:23 (local) 11/10/2010 09:57:23 (UTC). This is an informational message only; no user action is required.
    2010-10-11 11:57:35.43 Server Registry startup parameters:
    2010-10-11 11:57:35.43 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
    2010-10-11 11:57:35.43 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
    2010-10-11 11:57:35.43 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
    2010-10-11 11:57:35.45 Server Command Line Startup Parameters:
    2010-10-11 11:57:35.45 Server -m
    2010-10-11 11:57:35.45 Server -s SQLSERVER2005
    2010-10-11 11:57:35.46 Serveur SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2010-10-11 11:57:35.46 Serveur Detected 1 CPUs. This is an informational message; no user action is required.
    2010-10-11 11:57:35.87 Serveur Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
    2010-10-11 11:57:36.12 Serveur Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
    2010-10-11 11:57:37.87 Serveur Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
    2010-10-11 11:57:37.88 Serveur Database Mirroring Transport is disabled in the endpoint configuration.
    2010-10-11 11:57:37.92 spid5s Warning ******************
    2010-10-11 11:57:37.93 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.
    2010-10-11 11:57:37.93 spid5s Starting up database 'master'.
    2010-10-11 11:57:38.21 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2010-10-11 11:57:38.40 spid5s SQL Trace ID 1 was started by login "sa".
    2010-10-11 11:57:38.44 spid5s Starting up database 'mssqlsystemresource'.
    2010-10-11 11:57:38.48 spid5s The resource database build version is 9.00.4035. This is an informational message only. No user action is required.
    2010-10-11 11:57:39.16 spid5s Server name is 'TEST-SQL\SQLSERVER2005'. This is an informational message only. No user action is required.
    2010-10-11 11:57:39.16 spid8s Starting up database 'model'.
    2010-10-11 11:57:40.39 Serveur A self-generated certificate was successfully loaded for encryption.
    2010-10-11 11:57:40.41 Serveur Server is listening on [ 'any' <ipv4> 1163].
    2010-10-11 11:57:40.42 Serveur Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQLSERVER2005 ].
    2010-10-11 11:57:40.42 Serveur Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQLSERVER2005\sql\query ].
    2010-10-11 11:57:40.44 Serveur Server is listening on [ 127.0.0.1 <ipv4> 1164].
    2010-10-11 11:57:40.44 Serveur Dedicated admin connection support was established for listening locally on port 1164.
    2010-10-11 11:57:40.55 Serveur SQL Server is now ready for client connections. This is an informational message; no user action is required.
    2010-10-11 11:57:40.71 spid10s Starting up database 'msdb'.
    2010-10-11 11:57:40.72 spid11s Starting up database 'Redmine'.
    2010-10-11 11:57:40.73 spid12s Starting up database 'sem5'.
    2010-10-11 11:57:40.73 spid13s Starting up database 'ReportServer'.
    2010-10-11 11:57:40.98 spid8s Clearing tempdb database.
    2010-10-11 11:57:41.74 spid13s Starting up database 'ReportServerTempDB'.
    2010-10-11 11:57:41.77 Erreur : 18461, Gravité : 14, État : 1.
    2010-10-11 11:57:41.77 Login failed for user 'DOMAINE_GECIP\SQL_SRV'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT : <local machine>]
    2010-10-11 11:57:45.39 spid8s Starting up database 'tempdb'.
    2010-10-11 11:57:46.31 spid12s Analysis of database 'sem5' (9) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
    2010-10-11 11:57:47.33 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
    2010-10-11 11:57:47.34 spid5s Recovery is complete. This is an informational message only. No user action is required.
    2010-10-11 11:58:04.30 Erreur : 18461, Gravité : 14, État : 1.
    2010-10-11 11:58:04.30 Login failed for user 'DOMAINE_GECIP\administrateur'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT : <local machine>]
    2010-10-11 11:58:14.54 spid5s SQL Server shutdown due to Ctrl-C or Ctrl-Break signal. This is an informational message only. No user action is required.
    2010-10-11 11:58:14.54 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    There is a bug in the command line interface. Please download patch 1020 from here:

    ftp://support.red-gate.com/Patches/sql_ ... 0_1020.zip

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • SupportReseauGECIPSupportReseauGECIP Posts: 14
    Sorry Pete,

    It does not work : same errors.

    I believe it's because master db cannot be in a single-mode user. Don't you think?

    Patrice.
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    Once you've placed SQL Server in single user mode, try connecting using osql e.g.

    osql -E -S SQLSERVER2005

    Does that work?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • SupportReseauGECIPSupportReseauGECIP Posts: 14
    No it doesn't:

    [SQL Native Client]Named Pipes Provider- Could not open a connection to SQL Server [53].
    [SQL Native Client]Timeout expired
    [SQL Native Client] An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this faillure may be caused by the fact that under the default settings SQL Server does not allow remote connections

    Patrice.
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    Is it possible that another process/application has connected to the SQL Server instance the moment it was started, thus preventing other applications from connecting to it?

    Is there a corresponding error like the above i.e. 
    Login failed for user 'DOMAINE_GECIP\administrateur'. Reason: Server is in single user mode. Only one administrator can connect at this time. &#91;CLIENT : &lt;local machine&gt;&#93;
    when you tried to connect using osql?

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • SupportReseauGECIPSupportReseauGECIP Posts: 14
    Pete,

    Don't you have a MS SQL SERVER 2005 instance to test?

    Thanks.

    Patrice.
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    Don't you have a MS SQL SERVER 2005 instance to test?
    Yes I do, and that is what I have been testing on all this while.

    The problem now appears to be that another process/application is connecting to your SQL Server instance, thus preventing SQL Backup from connecting to it to perform the restore. You proved this yourself when you tried to connect to your instance using osql, which failed. I then asked that you check the SQL Server error log to confirm if this was indeed what was happening.

    Thanks.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • SupportReseauGECIPSupportReseauGECIP Posts: 14
    No I have not this error when I try the osql command
    · Share on Twitter
  • SupportReseauGECIPSupportReseauGECIP Posts: 14
    Thanks Pete,

    I founded my problem (shame on me!). I stopped all the sql products installed on my server i.e. SQL Integration Services, SQL Reporting Services, ... and it works fine now.

    I continue testing backup/restore.

    Thanks again.

    Patrice.
    · Share on Twitter
  • peteypetey Posts: 2,358 New member
    Thanks for the update, glad to hear you've resolved the issue.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
Sign In or Register to comment.