Saturday, February 25, 2012

Restore a database from SQL Server 2000 to SQL Server 2005 Express

Hi,
I'm trying to restore a database that existed in SQL Server 2000 to SQL
Server 2005 Express edition and I keep getting the following error:
System.Data.SqlClient.SqlError: Directory lookup for the file (name of the
file) failed with the operating system error 5(Access is denied.).
(Microsoft.SqlServer.Express.Smo)
I backed up the database using SQL Server 2000 and I simply want to restore
the database in 2005 Express.
The system is XP Professional and I am logged on as the administrator.
I'm using SQL Server and Windows Authentication mode in both SQL Server 2000
and in SQL Server 2005 Express.
Any ideas.
Thanks,
--
Scott H.Scott
Any errors in Event Viewer, SQL Server LOG file?
"Scott H." <ScottH@.discussions.microsoft.com> wrote in message
news:FD12F53E-3D00-4733-8FAD-42C4D790C03B@.microsoft.com...
> Hi,
> I'm trying to restore a database that existed in SQL Server 2000 to SQL
> Server 2005 Express edition and I keep getting the following error:
> System.Data.SqlClient.SqlError: Directory lookup for the file (name of the
> file) failed with the operating system error 5(Access is denied.).
> (Microsoft.SqlServer.Express.Smo)
> I backed up the database using SQL Server 2000 and I simply want to
> restore
> the database in 2005 Express.
> The system is XP Professional and I am logged on as the administrator.
> I'm using SQL Server and Windows Authentication mode in both SQL Server
> 2000
> and in SQL Server 2005 Express.
> Any ideas.
> Thanks,
> --
> Scott H.

No comments:

Post a Comment