How To Restore SQL Database
We are running Windows 2000, SP4, BE, ver. 9.0. I am testing to see if I
can restore a Northwind database. I got the error message. It said "An
error occured on a query to database Northwind. Device activation error.
The physical file name 'c:\program files\microsoft SQL Server\MSSQL\data\northwnd.mdf'
may be incorrect."
What am I doing wrong?
Thanks.
Re: How To Restore SQL Database
[QUOTE=unix;1375685]We are running Windows 2000, SP4, BE, ver. 9.0. I am testing to see if I
can restore a Northwind database. I got the error message. It said "An
error occured on a query to database Northwind. Device activation error.
The physical file name 'c:\program files\microsoft SQL Server\MSSQL\data\northwnd.mdf'
may be incorrect."
What am I doing wrong?
Thanks.[/QUOTE]
For working out given situation you may use [url=http://www.sqlserverrecoverytool.com]sql server recovery[/url]. The utility can work with sql files up to 16 TB. It starts under any software configurations of your system. The tool can recover mdf files from local area network.