How can we help you today? How can we help you today?
SupportReseauGECIP
Activity overview Badges (0) Posts (2) Comments (10)

Activity overview

Latest activity by SupportReseauGECIP

Hello, SQLBackup GUI works fine now because I restored Master DB ... obvious ? If you have any explanations. Thanks. Patrice. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Pb after restoring MSDB in command line
Hello, SQLBackup GUI works fine now because I restored Master DB ... obvious ? If you have any explanations. Thanks. Patrice.
0 votes
Pb after restoring MSDB in command line
  1. Community
  2. SQL Backup Previous Versions
Hello, Here's my SQL configuration : Source SQL Server : MS SQL Server 2000 version : 8.00.2082 (SP4) Target SQL Server : MS SQL Server 2000 version : 8.00.2082 (SP4) Instance name for both servers...
2 followers 2 comments 0 votes
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. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Pb restoring MASTER database
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 ...
0 votes
No I have not this error when I try the osql command / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Pb restoring MASTER database
No I have not this error when I try the osql command
0 votes
Pete, Don't you have a MS SQL SERVER 2005 instance to test? Thanks. Patrice. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Pb restoring MASTER database
Pete, Don't you have a MS SQL SERVER 2005 instance to test? Thanks. Patrice.
0 votes
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. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Pb restoring MASTER database
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 establishin...
0 votes
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. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Pb restoring MASTER database
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.
0 votes
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. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Pb restoring MASTER database
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 Micros...
0 votes
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. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Pb restoring MASTER database
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 com...
0 votes
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. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Pb restoring MASTER database
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.
0 votes
Total activity
14
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2