Re: MSDE vs MS SQL
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 08/17/04
- Next message: Wayne Snyder: "Re: how to start mail session?"
- Previous message: Richard Ding: "Re: CHECKDB causes tempdb to grow"
- In reply to: Sam: "Re: MSDE vs MS SQL"
- Next in thread: JoeyDBA: "Re: MSDE vs MS SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Aug 2004 17:00:42 -0400
I don't think you can convert, but you can backup the dbs from one and
restore them to the other. YOu can also use sp_detach_db and sp_attach_db to
the other...
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Sam" <cybersam88@hotmail.com> wrote in message news:uDt21cGhEHA.1656@TK2MSFTNGP09.phx.gbl... > It is possible that convert MSDE to MS SQL Server 2000 Standard Edition? > > Please help. > > > "Sam" <cybersam88@hotmail.com> wrote in message > news:OZCu$wFhEHA.3320@TK2MSFTNGP11.phx.gbl... > > There are two SQL running at my server as follows: > > - MSDE > > - MS SQL Server 2000 > > > > Issue > > - MSDE is act as core SQL Server which limited to 2GB per database size > > > > Info > > - Both SQL is running on MS Windows 2003 Server platform > > - MS SQL 2000 Analysis Service also installed and using MSDE database > > > > Inquiry > > - May I uninstall MSDE and MS SQL Server 2000, please? > > - Any issue / impact after I uninstall all? > > > > Question > > - I re-install MS SQL Server 2000 instead of MSDE because wrongly restore > > database at MSDE > > > > Please help. > > > > > >
- Next message: Wayne Snyder: "Re: how to start mail session?"
- Previous message: Richard Ding: "Re: CHECKDB causes tempdb to grow"
- In reply to: Sam: "Re: MSDE vs MS SQL"
- Next in thread: JoeyDBA: "Re: MSDE vs MS SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
