Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have a virtual machine running SQL Server 2012 in Azure and have also generated a script of my database to be run on the SQLSERVER2012 VM on Azure, however I am getting an error
"C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\PXDEV.mdf" failed with the operating system error 3 (The system cannot find the path specified.).
I have checked that path and the file is actually there on the source server.
Are you getting the error on the destination server?
Is the path present on the destination server?
You need to make sure that the paths defined in your CREATE DATABASE script exist on the destination server or you need to create them there.
Run the restore with file list only eg.
restore FILELISTONLY from disk= 'D:\MSSQL\full.bak'
to see where it is attempting to place the database files (observe the PhysicalName column). if that location (not the file the location) doesn't exist then you will need to move the file
This can be done by
RESTORE DATABASE @DatabaseName
FROM DISK = @filename
WITH
MOVE N'Filename1' TO N'D:\MSSQL\Datafiles\Primary.mdf',
MOVE N'Filename2' TO N'D:\MSSQL\Datafiles\SecondFile.ndf'
for example
