December 17, 2008 at 2:32 am
Hi,
I have SQL server with database(65 GB) consist of 6 secondary files. Everyday i am using Full backup file of database to restore as reporting database. Its always been a problem of consistent Execution of the DTS package which include
- Step 1 - Drop Database
- Step 2 - Restore Database
- Step 3 - Set Permissions to allow reporting application to connect to restored database
I am receiving following errors
SQL Log Messages
udopen: Operating system error 32(error not found) during the creation/opening of physical device F:\Data\Last_Secondary_File.NDF.
FCB::Open failed: Could not open device F:\Data\Last_Secondary_File.NDF for virtual device number (VDN) 8.
Event Viewer Error Messages
17207 :
udopen: Operating system error 32(error not found) during the creation/opening of physical device F:\Data\Last_Secondary_File.NDF.
17204 :
FCB::Open failed: Could not open device F:\Data\Last_Secondary_File.NDF for virtual device number (VDN) 8.
There is no other process or job running in parallel that might interrupt this restored process and anyway i am using backup(taken about 6 hours before restored process) file to restored database.
Thanks alot
December 17, 2008 at 3:03 am
can u manually try to perform each step and observe the sql error log?
December 17, 2008 at 4:50 am
I can run it manually. Its not a case that this package fails everyday but its fails often
December 17, 2008 at 4:57 am
what version is your SQL instance?
VDI backwards compatibilty has a known issue with VLDB's and SQLVDI errors
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2008 at 4:59 am
What do you use for making your backups?
Usually VDI errors occur when using some third-party backup solution, I've never seen them with native SQL Server backup.
[font="Verdana"]Markus Bohse[/font]
December 17, 2008 at 5:00 am
try to introduce a delay between each consecutive steps and keep it under observation.
waitfor delay '00:00:30'
December 17, 2008 at 7:11 am
Hi Guys,
The database is on SQL server 2000
December 17, 2008 at 7:13 am
Yes I am using Redgate SQL Backup tool to backup. Do you think that might causing job to fail? but i cant understand the reason why its generating error saying cant open last secondary file
December 17, 2008 at 7:17 am
This perticular job is created in SQL Server And what i am doing is dropping database and restoring it. but i am using backup taken by Redgate SQL Backup.
December 17, 2008 at 7:19 am
jayesh_kherwadi (12/17/2008)
Yes I am using Redgate SQL Backup tool to backup. Do you think that might causing job to fail? but i cant understand the reason why its generating error saying cant open last secondary file
Did you have a look at their site? You can find quite a lot in the forums there and they usually answer very fast on support requests.
[font="Verdana"]Markus Bohse[/font]
December 17, 2008 at 9:06 am
The os error 32 clearly tells that
The process cannot access the file because it is being used by another process.
December 17, 2008 at 11:27 am
jayesh_kherwadi (12/17/2008)
Hi Guys,The database is on SQL server 2000
this is the SQL2005 forum you have posted into
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply