Wrox Programmer Forums
|
BOOK: Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer
This is the forum to discuss the Wrox book Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer by Brian Knight, Devin Knight, Mike Davis, Wayne Snyder; ISBN: 978-1-1184-7958-2
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 29th, 2013, 01:29 PM
AJK AJK is offline
Registered User
 
Join Date: Nov 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Loading AdventureWorks DB fails

I installed SQL Server 2012 trial copy and I am attempting to load the AdventureWorks DB downloaded from
http://www.wrox.com/WileyCDA/Section/id-811019.html

The zip file only has a MDF file and no LDF.

The following error message is received when attempting to create the DB:

File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWor ks2012_Log.ldf" may be incorrect.
The log cannot be rebuilt when the primary file is read-only.
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks2012'. CREATE DATABASE is aborted.

Here is the create DB statement:
create database AdventureWorks2012 on (Filename = 'C:\AdventureWorks2012.mdf') for attach_rebuild_log;

Looking for help to resolve this issue.

Thanks...
 
Old June 15th, 2014, 12:46 AM
Registered User
 
Join Date: Jun 2014
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default The same problem in lesson 3 to attach database

I am the similar problem, I am using the SQL Server 2012Enter.. version.
I fallowed the instructions in Lesson 3 to download AdventureWorksDW2012 database from the Wrox website at www.wrox.com/go/SQLSever2012DataSets.

after unzip the mdf file to the folder SSIS at C:, the executed the code as
Code:
CREATE DATABASE AdventureWorksDW2012 ON 
(FILENAME = N'C:\ SSIS\AdventureWorks_DW_111810112X.mdf') FOR ATTACH_REBUILD_LOG
the the error messege as
Msg 5105, Level 16, State 2, Line 1
A file activation error occurred. The physical file name ' C:\ SSIS\AdventureWorks_DW_111810112X.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
Could anyone can help me to solve this problem, Thanks.





Similar Threads
Thread Thread Starter Forum Replies Last Post
AdventureWorks Links845 LINQ 5 June 24th, 2010 07:35 AM
INSERT Article fails also category fails too f117f117f117677 BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 3 November 4th, 2009 09:20 AM
loading items from DB to Treeview Medes C# 0 May 10th, 2006 08:32 AM
DB backup Job fails within a second or two happygv SQL Server 2000 6 October 16th, 2004 01:21 PM
loading a structured file in to db by command rameshkondru SQL Server DTS 0 February 3rd, 2004 07:37 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.