Click here to Skip to main content
15,921,622 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I have a c# .net windows service (scheduler on time basis).

Scheduler download database backup file from ftp and then restore .bak file in to the sqlexpress Database at particular time.

First of all, Scheduler downloads the database in to the C:\\DatabaseBackuup\abc.bak from ftp, and then restore database backup file from C:\\DatabaseBackuup\abc.bak into the sqlexpress database(my database name abc).

This scheduler It's running absulutly fine in windows XP but did not run in Windows 7,Database abc.bak file downloads successfully but did not restore, It's showing the error in my log File- Error: Restore failed foe server 'UserPC\sqlexpress'.

My DatabaseBackup folder automatically create through windows service in 'C:\\'.

Please help me regarding this error.

Thank You.

Ankit Agarwal
Software Engineer

1 solution

hi ankit,

check the dbname which you have stated in while restoring option.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900