Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Restore backup set

  
   Database Help (Home) -> MSDE RSS
Next:  backup script help!  
Author Message
Vijayakumar .Y

External


Since: Jun 24, 2008
Posts: 1



(Msg. 1) Posted: Tue Jun 24, 2008 6:25 pm
Post subject: Restore backup set
Archived from groups: microsoft>public>sqlserver>msde (more info?)
Hi all,
How can I restore a database backup set created from sql server 2005
developer edition to sql server express 2005?
Vijayakumar

 >> Stay informed about: Restore backup set 
Back to top
Login to vote
Andrea Montanari

External


Since: Sep 13, 2003
Posts: 498



(Msg. 2) Posted: Tue Jun 24, 2008 6:25 pm
Post subject: Re: Restore backup set [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
hi,
Vijayakumar .Y wrote:
> Hi all,
> How can I restore a database backup set created from sql server 2005
> developer edition to sql server express 2005?
> Vijayakumar

as long as the database does not exceed the SQLExpress edition limit of 4gb
per database, you should be able to restore that backup on a SQLExpress
instance.. you can do it via straight RESTORE statement or via a graphical
solution like SQL Server Management Studio (Express, in case of the
SQLExpress edition, qhich is free)..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply

 >> Stay informed about: Restore backup set 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
>> sqldmo restore - Hi, I am using VBA in an Access 2003 UI to restore a database in SQLExpress 2005. The following code snipet fails on the line oSQLServer.ExecuteImmediate with error -2147199229... The backup set holds a backup of a database other than the existing..

cannot backup SQL - I'm having trouble backing up SQL data using Microsoft SQL Server Management Studio Express. When I try backing up to the destination I get the error message: "Property backupdirectory is not availabe for Settings..

backup script help! - Hi, I am having a very difficult time trying to figure out how to write a script for a SQL backup. I will try and explain what I am trying to do. The majority of our computers out at customer sites are running access databases, however a few other..

Using SQL Server Enterprise Manager to Backup to Another S.. - Hi all ~ I've got SQL Server Enterprise Manager running on gb-01 and the database is located on gb-02. I'd like to get Enterprise Manager to backup the database located on gb02 to the other server gb01 across the network. Unfortunately, the file syste...

Install MSDE in XP - Hi all, I have a problem with MSDE installation. Here is the last part of error log. === Logging stopped: 10/10/2003 17:49:00 === MSI (c) (44:64): Note: 1: 1708 MSI (c) (44:64): Product: Microsoft SQL Server Desktop Engine -- Installation operation...
   Database Help (Home) -> MSDE All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]