Database Restore error --- SqlServer.Smo

  • Hi,

    I have created a new database ACCT with no problem. When I try to restore from the backup fro this database. it is giving me an error.

    Any idea how to resolved it. SQl --2005

    (Microsoft.SQLServer.Smo)

    System.Data.SQlClient.SqlError: Directory lookup for the file "C:\Program Files\Microosoft SQL Server\MSSQL.1\MSSQL\Data\ACCT.mdf" failed with operating sysstem error 2 (The system cannot find the file specified.).(Microsoft.SQLServer.Smo)

    Thank for the helop in advance

  • Was the backup taken from that database on that server? Or was taken from another server and you are restoring it to this server? Or was it taken from another database from this server?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply