AnsweredAssumed Answered

SQL 2012 restore

Question asked by Peggy Wu on Mar 24, 2014
Latest reply on Aug 11, 2016 by Matthe wrobbin

Hi,

I am doing restore SQL DB, following the bpg for Microsoft SQL server.Best Practices for Microsoft SQL Server

I am stocking at object-level restoration, describing in page10.

 

test1

create database recoveryDB

on

name recoveryDB  filename

'X:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\DB.mdf'

name recoveryDB_log filename

'Y:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\DB_log.ldf'

for attach;

failed to execute it, because of there is wrong arround 'name'

 

test2

CREATE DATABASE RecoveryDB

    ON

  (FILENAME = 'X:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\DB.mdf'),

  (FILENAME = 'Y:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\DB_log.ldf')

    FOR ATTACH;

give up test1, I tried test2, but still fail!!

error message:

FixupLogTail .....Y:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\DB_log.ldf is not able to be written.

 

does anyone successfully to do restore follow the bpg?

Please someone advise me where I made mistake.

 

OS: Windows 2008 R2

SQL 2012

NOS 1.4.11

NPM 1.4.62.2

Outcomes