Unable to restore database from msde to sql server

From: Jay Donnell (jaydonnell_at_yahoo.com)
Date: 08/23/04 

Date: 23 Aug 2004 14:29:03 -0700

I'm new to the windows side of things and sql server. I'm trying to
move a database in msde to sql server. The sql server is a shared
hosting account and I tried to do a backup and restore but the restore
gives me this error.

User does not have permission to RESTORE database 'mydb'

Is there any other way to easily move an msde database to sql server?

Relevant Pages

  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.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: msde2000
    ... Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, ... As for it being better than MS-Access, the answer to that is probable yes, ... MOST other database DO NOT. ...
    (microsoft.public.vc.mfc)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)