November 4, 2011 at 3:32 am
I have a job that makes full backup to my Datatases.
It is reporting this error in the job history:
Message
Executed as user: dbo. ...B', file 'DTBaseNET_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'AuditDB', file 'DTBaseNET_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 414273 pages in 104.237 seconds (32.557 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 140368 pages for database 'DBAudit_SGCTLocal', file 'SGCT_dat' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'DBAudit_SGCTLocal', file 'SGCT_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 140369 pages in 33.484 seconds (34.341 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 360 pages for database 'master', file 'master' on file 1. [SQLSTATE 01000] (Message 4035) Processed 2 pages for database 'master', file 'mastlog' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 362 pages in 0.175 seconds (16.922 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 1... The step failed.
Can someone help?
I don't know what is causing the error...
November 4, 2011 at 3:44 am
If i try to make backup to other databases that are not the system databases, the same error happens:
Executed as user: dbo. ...B', file 'DTBaseNET_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'AuditDB', file 'DTBaseNET_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 414273 pages in 99.756 seconds (34.020 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 140368 pages for database 'DBAudit_SGCTLocal', file 'SGCT_dat' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'DBAudit_SGCTLocal', file 'SGCT_log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 140369 pages in 33.830 seconds (33.990 MB/sec). [SQLSTATE 01000] (Message 3014) Processed 432 pages for database 'RepliCad', file 'DTBaseNET_Data' on file 1. [SQLSTATE 01000] (Message 4035) Processed 1 pages for database 'RepliCad', file 'DTBaseNET_Log' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE successfully processed 433 pages in 0.203 seconds (17.473 MB/sec). [SQLSTATE 01000] (Message 3... The step failed.
November 4, 2011 at 3:45 am
Job Code:
declare @NumRF as varchar(10)
declare @unc as varchar(500)
declare @srvname as varchar (100)
declare @date as varchar(25)
Declare @Nome as varchar(50)
DECLARE Backups CURSOR FOR
SELECT name from sys.databases where name <> 'tempdb' and name <> 'adventureworks' and name <> 'model' and name <> 'msdb' and name <> 'master' and state =0
--SELECT name from sys.databases where name ='RepliGai'
order by name
set @date = convert(varchar,getdate(),120)
set @date = replace(replace(@date,'-',''),':','')
set @srvname = (select convert(varchar,serverproperty ('servername')))
set @srvname = replace (@srvname,'\','-')
OPEN backups
FETCH NEXT FROM backups INTO @nome
WHILE @@FETCH_STATUS = 0
BEGIN
set @unc ='F:\database_backups\'+@nome+''
--set @unc =''
set @NumRF ='Lisboa'
if @unc =''
begin
exec('backup database ['+@nome+'] to disk =''g:\database_backups\'+@nome+'\'+@NumRF+'_'+@nome+'_'+@srvname+'_'+@date+'.BAK''')
end
else
exec('backup database ['+@nome+'] to disk ='''+@unc+'\'+@NumRF+'_'+@nome+'_'+@srvname+'_'+@date+'.BAK''')
FETCH NEXT FROM backups INTO @nome
END
CLOSE backups
DEALLOCATE backups
November 4, 2011 at 4:09 am
If you run that code in a query window, you'll get the full output and you'll be able to see which database is causing the problem.
John
November 4, 2011 at 7:58 am
Yap, problem solved.
Thank you
November 4, 2011 at 8:03 am
One more question if you do not mind....
I have a Dell Server which as one SQL Server 2000 instance and three SQl Server 2005 named instances.
The OS is W2k3 32bits.
I have 8GB of ram on the server.
I want to see all the memory available from the OS so i can performe faster querys i n SQL Server.
I am Thinking in Installing OS w2k8 64 bits or w2k3 64 bits.
Does w2k8 support SQL Server 2000?
Do i have a SQL Server 2000 64 bits edition?
Can i take see all the memory (8gb) in my SQL Server if it is in 32 bits even with OS in 64 bits?
What do i need to install so that my SQL Server 2000 and 2005 can see the 8gb?
Thanks
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply