Thanks for all the responses.

This thing is yeah, backup was running fine with no issues till it suddenly stopped. There haven't been any change in account, permmission or anything....

The Backup folder is shared and has all the required Full Control to Everyone as permission. The sqlserver agent Login account is an administrator.

No i cant. error message displays when i try to access using \\BRANCHSERVER2\Backup

In order for me to map a drive to a folder ii have to be able to access that folder and in which case i can't. And the name i'm...

Hi Steve,

I'm not able to connect to the remote server\folder on my system and its not a password issue becoz the password have changed. I'm currently logged into the remote...

hi John,

I have tried as you've suggested (\\remotesqlserver\Backup\databasename.bak) but it still didnt work...

Hi,

Pls i'm having the same torn page error and i can't seem to solve it. I don't have a backup of my msdb database. This is what i have...

Thank you very much for your response.

Here is the actual procedure that recovers the log file;

use master

if exists (SELECT * from sysobjects where id = object_id('dbo.sp_ApplyStandByLog') and sysstat & 0xf...

i have no NOLOCK statement in my procedure

About the sp4, I don't that yet but have sent for it and also my superior said that this error has occurred before and he can't remember being asked to...

Thanks for responding. I have ran chechdb and it report no issue. As for the san issue, will talk with the network team to look into that and will get...

Thanks for the info,pls how do i navigate to the Sql server 2000 forum, i am new

I have an DB Maintenance job that runs once a week and yes i have execute CHECKDB and no report of any error and the result to the query is...

it is a procedure that is called in the backup job

create procedure sp_bakdb

@dbname sysname ---name of the db to be backed up

@backuplocationpath nvarchar(256) ---unc...

its the actual database, but its online