The server side backups happen at a differen time however we have transactional log backups taken every 15 mins. But I cross checked the timing when the last step was...

Here is an example:

Table A

------------------------------------

Foldername expirydate finaldate

a ...

CREATE TABLE #a(foldername VARCHAR(10), expiryDate DATETIME, finalDate DATETIME)

CREATE TABLE #b (foldername varchar(10), folderDate DATETIME)

INSERT INTO #a VALUES('test1',GETDATE(), GETDATE())

INSERT INTO #a VALUES('test2',GETDATE(), GETDATE())

INSERT INTO #a VALUES('test3',GETDATE(), GETDATE())

INSERT INTO #a VALUES('test4',GETDATE(), GETDATE())

INSERT...

If anybody is in a similar situation , this might help....

I contacted Hyperbac and as Lynn said they got back to me in no time. All I had to do...

No, Everything went pretty smooth.

Here is the error that I get :

Read on E:\backup.zip failed.'A device attached to the system is not functioning'

verify database is terminating abnormally.

Any clue?

I am sorry but even when I give in the correct file location I get the same error message.

I have Hyperbac win extracter and Configuration manager installed , is...

Thanks for the reply. I plan to make a COPY of the files and the copying would done every night. Once the copying is done I plan to delete...

If I were to run ROBOCOPY, then is this the correct way to do it....

robocopy \\serverA\C:\Backup \\serverB\C:\backup

I placed the above syntax in one of the jobs under cmdexec type....

the...

The action is not being performed to obtain high availability/ disaster recovery but its something which involves netwrok usage on server A where the db reside.

A little help about how...

Any other suggestion??

Thanks.

Thanks Glenn,

But rite now there are baclups jobs available on the server and I need to replace the old backups jobs with the new ones.....

I cannot go with the same...

You would have no access to the jobs that are running if you have logged on to the server using SSMSE which is a free download and doesnt allow you...

Giving the 'execute' permission on that database for the user should fix the problem.

Yes, but when I had a look at the execution time, the order in which they were executed were the same as they we placed in control flow. The only...

Thank you ,but i figured it out I created a new profile with the correct server name and now its working.

Appreciate your help.