how to attach pdf file database to sqlserver 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » how to attach pdf file database to sqlserver...

how to attach pdf file database to sqlserver 2005

Rate Topic

Display Mode

Topic Options

Author

Message

venkata.gbit

Posted Wednesday, April 01, 2009 4:32 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 02, 2009 8:35 AM
Points: 3, Visits: 10

hi,

i download adventureworks database from msdn. i got this database as a pdf file. i want how to attach this pdf to sqlserver 2005 developer edition.

regards,
venkat.

Post #688461

Gift Peddie

Posted Wednesday, April 01, 2009 4:53 PM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:43 AM
Points: 3,432, Visits: 14,334

You must be missing something a SQL Server database comes as MDF and LDF or .BAKs which could be in .zip or .rar or MSI files but not PDF file. PDF files are text files so you need to check Codeplex for a new download.

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

Kind regards,
Gift Peddie

Post #688470

maechismo_8514

Posted Wednesday, April 01, 2009 5:09 PM

Ten Centuries

Group: General Forum Members
Last Login: Friday, August 24, 2012 8:11 AM
Points: 1,097, Visits: 2,157

Is that a typo? it should be mdf not pdf

CREATE DATABASE Adventureworks
ON FILENAME ='your path'
FOR ATTACH

or

Right-click on Databases and select Attach.

Click the Add button and select the database file to be attached.

Under database details, select the .LDF file and click the Remove button.

Click OK.

Post #688474

« Prev Topic | Next Topic »

Permissions