Converting a SQL Database to MSDE

From: MisterB (MisterB_at_discussions.microsoft.com)
Date: 12/30/04 

Date: Thu, 30 Dec 2004 10:23:03 -0800

Ok, I've got the tables created, the proc's created (and they work) and
everything else is done on the backend. My question is how to do I get
everything I've created in the database using a full version of SQL into an
MSDE database that I can distribute to my userbase so they can play. Someone
said all I need to do is a backup and restore -- but I'm not sure how it
would be done. Can anyone help?

Relevant Pages

  • Re: Backup/restore ADAM instance
    ... Stop "Backend" service. ... Try to backup the instance. ... Folder C:\Program Files\Microsoft ADAM\Backend\data ... Restore files to "Original location"). ...
    (microsoft.public.windows.server.active_directory)
  • Re: Cannot open SQL Server Table
    ... The backup was fine when I set up last summer. ... But when I tried to restore ... I think my client switched to SQL Server because the Access ... >> Backend. ...
    (microsoft.public.access.forms)
  • Re: Cannot open SQL Server Table
    ... The backup was fine when I set up last summer. ... But when I tried to restore ... I think my client switched to SQL Server because the Access ... >> Backend. ...
    (microsoft.public.access.externaldata)
  • Restoring SQL Server Backups
    ... I have an application that runs on a MSDE database. ... the 2005 database and restore the created backup. ... Restore yesterday's backup. ...
    (microsoft.public.sqlserver.server)
  • Backup MSDE database from .bat file
    ... I have seen hundreds of suggestions on how to backup a MSDE database on ... I also need to know how to restore such a backup;-) ... best regards ...
    (microsoft.public.sqlserver.msde)