Restoring a MSDE database on Full SQL

From: Peter (anonymous_at_discussions.microsoft.com)
Date: 02/28/05


Date: Mon, 28 Feb 2005 06:39:08 -0800

How do you backup a database that resides on MSDE and the
restore it on SQL Server 2000 and the remove the original
DBOwner and create a new one?



Relevant Pages

  • Re: Clarification:URGENT DB RESTORE INFO STILL REQUIRED
    ... I was wondering if anyone new if it was possible to restore a Database that was Backed up by SQL Server 2000 developer edition, into an Access 2002 Project that is CONNECTED TO A CURRENT VERSION OF MSDE. ...
    (microsoft.public.sqlserver.dts)
  • Re: MSDE vs MS SQL
    ... restore them to the other. ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... www.sqlpass.org "Sam" wrote in message ... > It is possible that convert MSDE to MS SQL Server 2000 Standard Edition? ...
    (microsoft.public.sqlserver.server)
  • Unable to restore database from msde to sql server
    ... I'm new to the windows side of things and sql server. ... hosting account and I tried to do a backup and restore but the restore ... User does not have permission to RESTORE database 'mydb' ... Is there any other way to easily move an msde database to sql server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Move a MSDE to SQL 2000
    ... > You can just make a backup of the database on MSDE and restore that on the ... That is all there is to it, assuming MSDE and SQL Server are ...
    (microsoft.public.sqlserver.msde)
  • RE: MSDE, Access, SharePoint... I am not sure where to ask this qu
    ... 1.>> What is the difference between MSDE and WMSDE? ... MSDE that is targeted for use by Windows components only. ... isn't SQL Server Express replacing MSDE and WMSDE? ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)