How can we help you today? How can we help you today?
oberion
Activity overview Badges (0) Posts (13) Comments (13)

Comments

Sort by recent activity
petey, I did that already and it still doesn't work. in the sql backup gui, I am unable to expand the cdb01 instance nor does it list the 6 databases associated with this instance, it has a red box next to it like it doesn't think the sql server is up. I couldn't install the sprocs and so forth so I had to drop the extended sproc. I am running sql 2005 w/ sp1 btw. Not sure if that helps. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. sqlbackup v4 on sql 2005
petey, I did that already and it still doesn't work. in the sql backup gui, I am unable to expand the cdb01 instance nor does it list the 6 databases associated with this instance, it has a red box...
0 votes
nevermind, I just saw the announcement for 4.2 that will support sql 2005 w/ sp1. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. sqlbackup v4 on sql 2005
nevermind, I just saw the announcement for 4.2 that will support sql 2005 w/ sp1.
0 votes
petey, is there a way to extend the timeout to say 30 seconds? Thanks. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. transaction log backup
petey, is there a way to extend the timeout to say 30 seconds? Thanks.
0 votes
petey wrote: Can you try starting the SQL Backup Agent service manually on that server? I have stopped and restarted the services successfully. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Failed to retrieve application version.
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
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup job failed with exit code: 0
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
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup job failed with exit code: 0
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
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup job failed with exit code: 0
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
  1. Community
  2. SQL Backup Previous Versions
  3. SQL Backup job failed with exit code: 0
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
  1. Community
  2. SQL Dependency Viewer
  3. software download?
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
  1. Community
  2. SQL Backup Previous Versions
  3. sql error 916
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
Total activity
33
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
7