Hello,
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