User profile for RussF

Hi Brian, Thanks, sorted. Russ / comments

Hi Brian, Thanks, sorted. Russ

0 votes

Hi Brian, Looked at the logs again and you are right, it fails on the 1st attempt and on the 2nd attempt it runs successfully. I will to see if SQL is potentially busy with something else at that time. Thanks Russ / comments

Hi Brian, Looked at the logs again and you are right, it fails on the 1st attempt and on the 2nd attempt it runs successfully. I will to see if SQL is potentially busy with something else at that t...

0 votes

Hi Guys, Had the same error this morning when trying to license a trial that expired. Was not service related, copying the activation .exe to the server sorted the problem out. Thanks Russ / comments

Hi Guys, Had the same error this morning when trying to license a trial that expired. Was not service related, copying the activation .exe to the server sorted the problem out. Thanks Russ

0 votes

Hi James, Problem sorted. Thanks for such a prompt response, brilliant support! Russell / comments

Hi James, Problem sorted. Thanks for such a prompt response, brilliant support! Russell

0 votes

Hi Peter, Just to add to the ?. This only occurs on one of my servers on the LAN, I have other servers backing up perfectly. The server is Win2003 SP1 Enterprise with SQL 2000 Enterprise SP3a 4 way Xeon IBM 8 Gig physical memory We also run SQL replication on that box. Thanks Russell / comments

Hi Peter, Just to add to the ?. This only occurs on one of my servers on the LAN, I have other servers backing up perfectly. The server is Win2003 SP1 Enterprise with SQL 2000 Enterprise SP3a 4 way...

0 votes

Hi Peter, The pubs DB which is 1.25meg backs up with no issue via the GUI or using the SQL statement. When I try a DB larger such as DB called interface @ 725meg it fails even if I use your statement and use the lowest value: master..sqlbackup '-sql "BACKUP DATABASE interface TO DISK = [\\rbsbackup01\SQL Daily\RBSMERSRV01\interface.sqb] WITH MAXTRANSFERSIZE = 65536" ' See error below: Backing up interface (full database) on MERLIN_PROD instance to: \\rbsbackup01\SQL Daily\RBSMERSRV01\interface.sqb Thread 0 error: Error 620: Error writing to backup file(s). Process terminated unexpectedly. Error code: -2139684860 Server: Msg 3013 BACKUP DATABASE is terminating abnormally. Server: Msg 3202 Write on 'SQLBACKUP_628EEFA3-6247-4294-87F9-49C2D582AF9C' failed, status = 112. See the SQL Server error log for more details. SQL Backup exit code: 790 SQL error code: 3202 More details - I am currently backing up other SQL servers with DB's of around 26gig perfectly to the same share usingn SQLbackup, so permissions is not an issue. - I can successfully perform a SQLbackup of any DB on the 'problem' server locally, problem only when doing so to a network share, also tried another network share with the same results. Thanks Russell / comments

Hi Peter, The pubs DB which is 1.25meg backs up with no issue via the GUI or using the SQL statement. When I try a DB larger such as DB called interface @ 725meg it fails even if I use your stateme...

0 votes

Hi Peter, Thanks, managed to get it working on , MAXDATABLOCK = 458752"' Is this issue due to there not being enough physical memory to service the request for backup? Thanks Russell / comments

Hi Peter, Thanks, managed to get it working on , MAXDATABLOCK = 458752"' Is this issue due to there not being enough physical memory to service the request for backup? Thanks Russell

0 votes

How can we help you today?

RussF

Comments