Comments
Sort by recent activity
Hello,
SQLBackup GUI works fine now because I restored Master DB ... obvious ?
If you have any explanations.
Thanks.
Patrice. / comments
Hello,
SQLBackup GUI works fine now because I restored Master DB ... obvious ?
If you have any explanations.
Thanks.
Patrice.
No I have not this error when I try the osql command / comments
No I have not this error when I try the osql command
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
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 ...
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
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...
Pete,
Don't you have a MS SQL SERVER 2005 instance to test?
Thanks.
Patrice. / comments
Pete,
Don't you have a MS SQL SERVER 2005 instance to test?
Thanks.
Patrice.
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
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.
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
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.
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
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...
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. / comments
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...