User profile for oberion

petey wrote: Can you try starting the SQL Backup Agent service manually on that server? I have stopped and restarted the services successfully. / comments

petey wrote: Can you try starting the SQL Backup Agent service manually on that server? I have stopped and restarted the services successfully.

0 votes

this is the log from C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log SQL Backup log file [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. when I run as domain user: dba2, using: exec master..sqlbackup N'-SQL "BACKUP DATABASE [Reference01] TO DISK = ''F:\sqlbackups\usr_db_full\FULL_(local)_Reference01_20060210_203520.sqb'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', COMPRESSION = 3"' I get the following output: SQL Backup (DLL v4.0.0.113) Backing up Reference01 (full database) to: F:\sqlbackups\usr_db_full\FULL_(local)_Reference01_20060210_203520.sqb [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. SQL error code: 17 (6 row(s) affected) name value exitcode 0 sqlerrorcode 17 filename01 F:\sqlbackups\usr_db_full\FULL_(local)_Reference01_20060210_203520.sqb (3 row(s) affected) Running the same t-sql statement as domain user: dba I get the same error output. MAYBE the following can help resolve this problem. This server runs 3 instances named: tst, stage, and mir tst is on port 3852 stage is on port 1433 mir is on port 1804 this server is set up on a two node clustered and uses 3 virtual names: tst\tst stage\stage mir\mir When we use Windows Remote Desktop Connection to connect to these instances, we would type in 'tst' or 'stage' or 'mir' all of the names just listed are virtual ... it takes us to one of the active clustered server (either dbstage1 or dbstage2). When I connect directly to dbstage1 and not use the virtual name, I can't telnet into any of those ports using: telnet localhost 3852 or 1433 or 1804 BUT when I do: telnet tst 3852, I get connected same goes for stage 1433 and mir 1804 .. maybe this has something to do with this whole mess? I know this is a complicated setup but still need to figure out a way to get this sqlback to work. please further advise. / comments

this is the log from C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\LogSQL Backup log file [DBNETLIB][ConnectionOpen (Connect()).]SQL Serve...

0 votes

I downloaded and installed the new version 4.1 on my laptop to test first. During the upgrade process, I got some error: Cannot read mutli_sz value/kann den mutli_sz wert nicht lesen... I have no idea what the heck that means as it is not in English except for the beginning portion. The installation complete and I launched the sql backup GUI. In the database listing, I see duplicate databases. So the all the database is showing up 3 times instead of just once. I went ahead and uninstall the application and reinstall, the results are the same. What's the best way to upgrade this application without having to reinstall and prevent having the DB being listed multiple times?[/quote] / comments

I downloaded and installed the new version 4.1 on my laptop to test first. During the upgrade process, I got some error: Cannot read mutli_sz value/kann den mutli_sz wert nicht lesen... I have ...

0 votes

Petey, yeah, I was referring to useig the built in sql backup command via Query Analyzer backup database DB to disk = '\\path\to\backup' Brian, I tried backing one of my database via the GUI of the sqlbackup4 pro application and it would fail to backup as well. Does sqlbackup4 pro provide a more detail log somewhere so I can look and try to troubleshoot from there? thanks / comments

Petey, yeah, I was referring to useig the built in sql backup command via Query Analyzerbackup database DB to disk = '\\path\to\backup' Brian, I tried backing one of my database via the GUI of th...

0 votes

petey wrote: SQL Server error code 17 indicates that the SQL Server could not be found or access was denied. When you mention that the backup fails via the SQL Backup GUI, does it fail at the end of the backup wizard, or when you connect to it initially? What is the error that's displayed on the GUI? Petey, it fails right at the beginning of the job. I have two SQL service account that have the same exact permissions. I have used both and both had failed with the error I've indiciated. / comments

petey wrote: SQL Server error code 17 indicates that the SQL Server could not be found or access was denied. When you mention that the backup fails via the SQL Backup GUI, does it fail at the e...

0 votes

thank you. / comments

thank you.

0 votes

Petey, thanks for the info. Spoke with Brian D. about this on the phone and I asked why there wasn't a prompt asking us to use to local system account or enter a different account for this service. Hopefully in the next upgrade this will be incorporated? Because changing 40+ windows services doesn't sound like fun to me. / comments

Petey, thanks for the info. Spoke with Brian D. about this on the phone and I asked why there wasn't a prompt asking us to use to local system account or enter a different account for this service....

0 votes

Thanks for the prompt response petey. The link you gave me ( www.red-gate.com/support/help_files/sqlbackup.chm) doesn't seem to work. I would download the .chm file but when I open it, all I get is page can't be display.. / comments

Thanks for the prompt response petey. The link you gave me ( www.red-gate.com/support/help_files/sqlbackup.chm) doesn't seem to work. I would download the .chm file but when I open it, all I get i...

0 votes

yup, that did the trick. / comments

yup, that did the trick.

0 votes

petey, thanks for your response. I have 7 instances on a single box, do I need to enter the license key for 7 instances or will one suffice? Thanks. / comments

petey, thanks for your response. I have 7 instances on a single box, do I need to enter the license key for 7 instances or will one suffice? Thanks.

0 votes

How can we help you today?

oberion

Comments