Re: Clarification:URGENT DB RESTORE INFO STILL REQUIRED
- From: Ed Enstrom <nospam@xxxxxxxxxxx>
- Date: Tue, 27 Jun 2006 18:43:36 -0400
Frank Srebot wrote:
Hi
I had a previous question and I have to clarify. I am using an Access 2002 Project that is CONNECTED TO A CURRENT VERSION OF MSDE (NOT SQL Server Espress).
I was wondering if anyone new if it was possible to restore a Database that was Backed up by SQL Server 2000 developer edition, into an Access 2002 Project that is CONNECTED TO A CURRENT VERSION OF MSDE (NOT SQL Server Espress). I have been told that it was possible and one of the responses I got was:
'What you need to do is specify a new file location for the .mdf and .ldf files during restore using the WITH MOVE syntax.'
During the retore process in an access Project, there is no configuration for this syntax (unless you can do it by VBA??).
I had no problem doing this when I restored using the demo version of SQL SERVER 2005 (It gave me no errors) , but the same process does not work in Access 2002 project that is CONNECTED TO A CURRENT VERSION OF MSDE (NOT SQL Server Espress).
Any Ideas?
Thanks
Frank Srebot
You restore the SQL2K database backup to the MSDE database. You need to use the WITH MOVE clause because the file locations of the SQL2K database are probably different from the locations of the MSDE database. The links from Access to the MSDE instance don't change.
Or am I missing something?
.
- Prev by Date: sql 2005 / evaluation expiring (but not really - purchased copy)
- Next by Date: RE: import password protected file into SQL
- Previous by thread: sql 2005 / evaluation expiring (but not really - purchased copy)
- Next by thread: RE: import password protected file into SQL
- Index(es):
Relevant Pages
|
