Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old May 7th, 2005, 09:38 AM
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default getting the database from the backup file

Hello all!
I'm using Microsoft SQL Express with SQL Express Manager as my core database server for the project.
I have downloaded the code that goes with this Wrox book, but the database included is a backup version (.BAK file). I don't know how to open this database in SQL Express Manager.
Can anybody help me please, so I can continue with the project?
Many thanks
Ben

  #2 (permalink)  
Old May 7th, 2005, 09:08 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The database comes in 2 formats: one is a SQL 2000 backup, and the other is a SQL 7 backup. There's also a script, but that wasn't updated after the book was published, so I wouldn't use the SQL script.

Do some google searching to learn how to restore a database backup. If it's not in the menus of SQL Express (the Manager is the new GUI tool that replaces Enterprise Manager and Query Analyzer), then you can use SQL commands to do it.

But, SQL Express is a beta of SQL Server 2005, and this database backup was never certified to be compatible with this version. I think it will work, but I can't offer you much support for it.

If you're using the beta version of Visual Studio 2005, or the new Web Developer GUI, the same advice applies: it should work but there are no guarantees.

Eric
  #3 (permalink)  
Old May 8th, 2005, 06:15 AM
Authorized User
 
Join Date: Jun 2004
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Eric,
I followed your advice and found a script to restore the database on this very site:

http://p2p.wrox.com/topic.asp?whichp...ID=28816#67070

I don't understand a word of it but I made some educated guesses and managed to adapt it to my purposes. For everyone's information, it seemed to work just fine, I can see a list of all the tables and queries mentioned in the book now. No compatibility issues.

My biggest surprise was finding out exactly how little I can do with Sql Express Manager. Am I missing something, or do I have to perform everything by typing commands into the query analyser? It won't even let me copy and paste tables! Anybody know where I can learn to do this efficiently? Anybody know if there's an easier option available to me?

  #4 (permalink)  
Old May 9th, 2005, 12:11 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Keep in mind that you are using the Express version - which is the 2005 free version. Compare the SQL Manager with the graphical tools that came with MSDE (the free version of SQL 2000) - MSDE had zero free graphical tools! Even a little bit is a big improvement.

Also, this is still a beta. The final release should be better.

I know that the final relase of the full SQL 2005 product (not the express version) is supposed to have a very nice SQL Manager that is better than anything SQL 2000 had. It's also going to be a bit like Visual Studio, and VS 2005 will have better connectivity to both Oracle and SQL Server.

Eric
  #5 (permalink)  
Old May 13th, 2005, 12:32 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are you using the April CTP version of SQL Express with this manager GUI:
http://www.microsoft.com/downloads/d...displaylang=en
  #6 (permalink)  
Old June 10th, 2005, 02:47 PM
Registered User
 
Join Date: Jun 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I didn't seem to get the SQL 7 backup in my download. Is it still available?

When I tried to restore the database I got an error message stating it was the wrong version.


Quote:
quote:Originally posted by englere
 The database comes in 2 formats: one is a SQL 2000 backup, and the other is a SQL 7 backup. There's also a script, but that wasn't updated after the book was published, so I wouldn't use the SQL script.

Do some google searching to learn how to restore a database backup. If it's not in the menus of SQL Express (the Manager is the new GUI tool that replaces Enterprise Manager and Query Analyzer), then you can use SQL commands to do it.

But, SQL Express is a beta of SQL Server 2005, and this database backup was never certified to be compatible with this version. I think it will work, but I can't offer you much support for it.

If you're using the beta version of Visual Studio 2005, or the new Web Developer GUI, the same advice applies: it should work but there are no guarantees.

Eric
  #7 (permalink)  
Old June 12th, 2005, 11:50 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Please look for it carefully. The SQL 7 backup file is named differently from the SQL 2K file. I don't remember the filename but I think you can find it. You may have to get the code download for the C# version to find it.

I'm not sure it's wise to use SQL 7 now that SQL 2005 is almost out. Even SQL 2000 is getting pretty old now. But SQL 7 should work fine if you insist on using it. There's nothing in this application that requires newer features than those in SQL 7.
 


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
backup of database MunishBhatia SQL Server 2005 0 October 5th, 2007 05:20 AM
Backup of Database (C#) meljab BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 March 31st, 2007 12:45 PM
Backup Database gaurav_jain2403 SQL Server 2000 0 August 3rd, 2006 01:57 AM
The database backup file Malnad BOOK: ASP.NET Website Programming Problem-Design-Solution 0 January 10th, 2006 12:19 AM
Database Backup prakash.wadkar ADO.NET 1 February 22nd, 2005 01:06 PM



All times are GMT -4. The time now is 06:31 PM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.