Re: URGENT DB RESTORE INFO STILL REQUIRED
- From: Darren Green <darren.green@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 25 Jun 2006 09:42:16 +0000 (UTC)
Hello Frank,
You cannot restore SQL Server into Access, regardless of versions. I am not aware of any downside options either. People normally wish to migrate the other way, or if you want SQL on the desktop you would use one of the normal SQL SKUs or even SQL Express.
The WITH MOVE syntax is for moving the location of data and log files, when restoring to another SQL Server. There is no support for Access in this way.
Hi
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. 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.
Any Ideas?
Thanks
Frank Srebot
.
- Prev by Date: ssis web service task timeout
- Next by Date: Re: Creating a flat file destination on a CD-ROM
- Previous by thread: ssis web service task timeout
- Next by thread: DTS Package - Destination Server is now off of domain.
- Index(es):
Relevant Pages
|
