I am trying to restore a database. The backuo file is on c$. The restore
is not successful. The error message on the Event Viewer is "could not open
file."
Now if I move the backup file to d$, I can restore the db without any
problem.
I can restore other databases from c$ with the same permissions on the .bak
file.
?Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you will have to move backup data
files to disk D other than disk C to restore it successfully. If I have
misunderstood your concern, please feel free to point it out.
This is a really strange issue and would you please help me check the
following things?
1. Whether the Windows login user has administrator permission or it has
the permission to access all disk C and disk D files.
2. You restore the file from Enterprise Manager or Query Analyzer? Could
you let me know what the SQL error log say?
3. Please reconfirm the correct typed database name in Disk C
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment