@ amy

Tht script was very nice....thxs

but i couldnt get system stored procedures from that...is it possible to get tht?

Thanks,

Regards,

Sushant

@ amol

I copied the bak files from source server to this destination server.

Now, the problem i am facing is due to the restoring failing with the mentioned error.

Regards,

Sushant

@ nj-dba

Its confusing wat u intend to say?

@ashish

Ya, i changed it . hav to wait to c the results. I shld wish nobody else manually deletes the bak files after...

ya, i used the option verify backup when finished.

But this error is not due to faulty bak file,

when there is some corrupted bak file then, when we restore the db,...

@ steve

Ya, i logged in as the sql agent service account and was able to delete the files manually.

Thanks.

Regards,

Sushant

@ vivek

🙁

@NJ-DBA

Ya, that error shouldn't come when i copied the file locally..

How could I divide the bak file into 10 parts as you suggested..?

and restoring part also,...

@NJ-DBA

Yes the sql agent is running as a domain user.

@ashish

hahaha.....so true buddy

Regards,

Sushant

@ jeffrey

I am taking backups and storing them on different server..

I am also clueless, what mistake I did.

Anywayz, thanks for your replies.

Regards,

Sushant

Does anybody know, if i again start the restoring process so it should start from 70%

or it will start from scratch??

Regards,

Sushant

I copied the file locally to the destination server

When i tried doing restoring,

i got the error after about 70% was restored:-

Msg 64, Level 20, State 0, Line 0

A transport-level error...

@ jeffrey

The priya folder is shared by everyone with full control, change ,read.

In security, admins, domain admins and sql server agent are given the permissions.

Admins hav all permission, domian...

@ jeffrey

The exact location of the bak file is :-

\\server_name\D:\ABC(shared)\Priya(shared)\db_name.bak

in back up task, I' mentioned \\server_name\Priya ...

I made new maintenance plan with only maintenace cleanup task

and speciifed the location and put a dummy bak file

I ran tht job and then it was successful but the bak...

@ jeffrey

EXECUTE master.dbo.xp_delete_file 0,N'\\server_name\Priya',N'bak',N'09/05/2010 12:21:24'

Regards,

Sushant

@ ashish

Yes, i can try that...

@NJ-DBA

In the backup task, the create subdirectory checkbox hasn't been checked

In the cleanup task, the folder which is mentioned in the backup task...