Automatic Bakup Error

Question

Automatic Bakup Error

divyeshnh

Valued Member

Points: 52
More actions
March 23, 2009 at 10:47 pm

#207712

Hello Friends,
I am a doing a things that when any application instance start at that time i start one timer that moniter the entier application. and also i create schedule that on some time base and on per day. but the problem is that i write a script command in that i use the root directory part to store the backup. it works fine but when the backup command executed at that time it gives me a following error .
ERROR IS :
Cannot open backup device 'C:\Inetpub\vhosts\httpdocs\Full_BackUp_of_Database_at_21032009_092140AM.bak'. Device error or device off-line. See the SQL Server error log for more details. BACKUP DATABASE is terminating abnormally.
Please any one replay me so, that i do further
Thanks you.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Does the directory C:\Inetpub\vhosts\httpdocs\ exist? Does the SQL Service account have access to it?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

divyeshnh Valued Member Points: 52 More actions · Answer 2

Thanks For reply,

yes there is a director exists in the drive that i already check out

Thanks

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

GilaMonster (3/24/2009)
Does the SQL Service account have access to it?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

divyeshnh Valued Member Points: 52 More actions · Answer 4

i read yr answer very carefully & study all the things that u previously say. after that i try another thing that is i place that code on one button click event and fortunately i got success. so, i ask you when i try to do with schedule it will raised me an error while i click on button & take backup it will work fine. so, please give me answer about this.

Thank you for your reply

Thanks

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 5

Problem with your path provided in Backup statement. for more info see SQL BOL.

Possible, post the script.

divyeshnh Valued Member Points: 52 More actions · Answer 6

Thank you Kishore. but i think i told that my path work very fine because i tell that i use already with user interection but when it would be scheduled it will give error. so, alternatively i comes on one thing that i use what ever path that is right but it could not place a backup file at that location why that i do't know?

Thank you for your reply

Thanks