RESTORE SQL Server to msde?

Is it possible?
How about all dev in sql server then migrate to "production msde" using either DTS or bcp and DDL scripts?
Can you bcp in to msde? And is msde true client server?This is a start!


http://groups.google.com/groups?q=msde+database+restore&hl=en&lr=&ie=UTF-8&group=microsoft.public.sqlserver.*&selm=2l7qo3F9s4e1U1%40uni-berlin.de&rnum=3|||MSDE is the desktop version of SQL Server. It is limited in terms of only 2 Gb per database, and only 5 simultaneous active spids per instance, but those are the only significant limitations.

I don't remember if BCP is included in the executables, although OSQL.EXE definitely is. The Transact-SQL BULK INSERT command works just fine, and is simply a different interface to the same API that BCP uses.

DTS works on an MSDE instance without any reservations that I know of, other than the limitations imposed by MSDE itself.

-PatP|||Cool...so if they want this application to be distributable...should be no problem...right?|||No problem I can see. Don't overlook the easy answer if you can just detach the database and zip it though!

-PatP

Restore SQL database (MSDE)

Hi!
We had to resoft our PC, but before we formatted the whole PC, we made a
backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
get the error message "The backup set holds a database other than the
existing 'our dbname' database". Both the old and the new db was created
with MSAccess, and when we try to restore with Access (adp), we get a
similar error msg.
Any ideas?
TIA
Ulf H.Read about the RESTORE command in Books Online, and especially the MOVE and REPLACE parameters.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ulf Hansen" <someone@.somewhere.com> wrote in message news:j1OWc.2838$g%5.36571@.news2.e.nsc.no...
> Hi!
> We had to resoft our PC, but before we formatted the whole PC, we made a
> backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
> etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
> restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
> get the error message "The backup set holds a database other than the
> existing 'our dbname' database". Both the old and the new db was created
> with MSAccess, and when we try to restore with Access (adp), we get a
> similar error msg.
> Any ideas?
> TIA
> Ulf H.
>|||Hi Ulf,
Thanks for using MSDN Managed Newsgroup!
Thanks MVP Tibor's greatest answer! How are things going on yours? Have you
use RESTORE successfully? I would appreciate it if you could post here to
let me know the status of the issue. If you have any questions or concerns,
please don't hesitate to let me know. I look forward to hearing from you,
and I am happy to be of assistance.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Restore SQL database (MSDE)

Hi!
We had to resoft our PC, but before we formatted the whole PC, we made a
backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
get the error message "The backup set holds a database other than the
existing 'our dbname' database". Both the old and the new db was created
with MSAccess, and when we try to restore with Access (adp), we get a
similar error msg.
Any ideas?
TIA
Ulf H.Read about the RESTORE command in Books Online, and especially the MOVE and
REPLACE parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ulf Hansen" <someone@.somewhere.com> wrote in message news:j1OWc.2838$g%5.36571@.news2.e.nsc.
no...
> Hi!
> We had to resoft our PC, but before we formatted the whole PC, we made a
> backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
> etc.). Now, after we have installed MSDE on the "clean" PC, we're trying t
o
> restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
> get the error message "The backup set holds a database other than the
> existing 'our dbname' database". Both the old and the new db was created
> with MSAccess, and when we try to restore with Access (adp), we get a
> similar error msg.
> Any ideas?
> TIA
> Ulf H.
>|||Hi Ulf,
Thanks for using MSDN Managed Newsgroup!
Thanks MVP Tibor's greatest answer! How are things going on yours? Have you
use RESTORE successfully? I would appreciate it if you could post here to
let me know the status of the issue. If you have any questions or concerns,
please don't hesitate to let me know. I look forward to hearing from you,
and I am happy to be of assistance.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Restore SQL database (MSDE)

Hi!
We had to resoft our PC, but before we formatted the whole PC, we made a
backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
get the error message "The backup set holds a database other than the
existing 'our dbname' database". Both the old and the new db was created
with MSAccess, and when we try to restore with Access (adp), we get a
similar error msg.
Any ideas?
TIA
Ulf H.
Read about the RESTORE command in Books Online, and especially the MOVE and REPLACE parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ulf Hansen" <someone@.somewhere.com> wrote in message news:j1OWc.2838$g%5.36571@.news2.e.nsc.no...
> Hi!
> We had to resoft our PC, but before we formatted the whole PC, we made a
> backup of the MSDE db with OSQL (Osql "Backup database 'our dbname'...
> etc.). Now, after we have installed MSDE on the "clean" PC, we're trying to
> restore the db with Osql, ("Restore database 'our dbname'... etc.) but we
> get the error message "The backup set holds a database other than the
> existing 'our dbname' database". Both the old and the new db was created
> with MSAccess, and when we try to restore with Access (adp), we get a
> similar error msg.
> Any ideas?
> TIA
> Ulf H.
>
|||Hi Ulf,
Thanks for using MSDN Managed Newsgroup!
Thanks MVP Tibor's greatest answer! How are things going on yours? Have you
use RESTORE successfully? I would appreciate it if you could post here to
let me know the status of the issue. If you have any questions or concerns,
please don't hesitate to let me know. I look forward to hearing from you,
and I am happy to be of assistance.
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

restore problems

I have a db on msde on one server.
I"d like to replicate it by restoring a back up on another PC with a newly
installed MSDE.
I create a shell of the DB
I create a user name which my application uses to login with SQL
authentication.
I give the user db access to the empty-shell to be filled in by the backup
I proceed with the restore.
After the restore is done, the user I created now loses the access to the
db.
When I try to reset the dbaccess for the user, I get an error that says the
user already exists,
This is most liklely because that user name is the owner of some of the
tables in restored DB.
Any ideas as to how to do a restore correctly?
Many Thanks in advance
ps.. I've tried sql-copy and that was a teerrible disatster as I got olst
figuring out what the heck a service account is.
hi Ernesto,
"Ernesto" <tsh@.mathematicuslabs.com> ha scritto nel messaggio
news:iqOdnZtH1JOec2PdRVn-rA@.speakeasy.net...
> I have a db on msde on one server.
> I"d like to replicate it by restoring a back up on another PC with a newly
> installed MSDE.
> I create a shell of the DB
> I create a user name which my application uses to login with SQL
> authentication.
> I give the user db access to the empty-shell to be filled in by the backup
> I proceed with the restore.
> After the restore is done, the user I created now loses the access to the
> db.
> When I try to reset the dbaccess for the user, I get an error that says
the
> user already exists,
> This is most liklely because that user name is the owner of some of the
> tables in restored DB.
> Any ideas as to how to do a restore correctly?
> Many Thanks in advance
> ps.. I've tried sql-copy and that was a teerrible disatster as I got olst
> figuring out what the heck a service account is.
>
if the "user" shoul'd be the database owner as well, do not make the
corresponing login a dbuser by granting him access to the db..
just restore the db and change the db ownership to your login , which will
automatically grant him access and ownership rights...
EXEC sp_changedbowner 'login' , 'true'
please see
http://msdn.microsoft.com/library/de...ca-cz_30s2.asp
for it's related synopsis and further info
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I guess I shoudl have mentioned that the problem SEEMs to be that the
created user mysteriously loses its "login" name after the restore.
I found out that the query:
sp_change_users_login 'auto_fix', 'username'
Fixed the problem.
I've looked at sp_changedbowner and it just changes the owner of the db. It
does not fix the user problem.
sp_changedbowner accepts a login name as the parameter, and the problem was
that hhuser did not have a login name after the restore.
Now if I only could find a smoother way of doing this whole restore thing
without all the hassle of creating an empty db, creatina login, restoring,
and fixing the login!!
Sure looks like this ms product has a long way to go before it is user
froiendly even in its more common aspects like restoring a legitimate
backup.
|||hi Ernesto,
"Ernesto" <tsh@.mathematicuslabs.com> ha scritto nel messaggio
news:hc6dndtw6OTxRGLdRVn-hQ@.speakeasy.net...
> I guess I shoudl have mentioned that the problem SEEMs to be that the
> created user mysteriously loses its "login" name after the restore.
> I found out that the query:
> sp_change_users_login 'auto_fix', 'username'
> Fixed the problem.
>
> I've looked at sp_changedbowner and it just changes the owner of the db.
It
> does not fix the user problem.
> sp_changedbowner accepts a login name as the parameter, and the problem
was
> that hhuser did not have a login name after the restore.
> Now if I only could find a smoother way of doing this whole restore thing
> without all the hassle of creating an empty db, creatina login, restoring,
> and fixing the login!!
> Sure looks like this ms product has a long way to go before it is user
> froiendly even in its more common aspects like restoring a legitimate
> backup.
as regard this last sentence, my opinion is not Microsoft "has a long way to
go.." but just us understand how it works..
MSDE/SQL Server is NOT JET, and we have to take care understanding ith'
behaviours..
anyway,
http://www.sqlservercentral.com/colu...okenlogins.asp
Neil Boyle article about this related issue is worth reading, IMHO
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

restore msdb - MSDE 2000

hi. i'm trying to restore msdb (dmp)... the dmp was taken from MS Desktop Engine 2000 and i'm trying to restore it to ms sql server 2000. is this possible? if not, how can i restore msdb to MSDE 2000? can't remember the command. (matter is a little urgent)

Thanks!

First, Stop the SQL Server Agent Service, then start the SQL Server Service and execute it:

RESTORE DATABASE msdb FROM DISK='c:\backup\msdb_backup.bak'

Regards and Happy new Year,

|||

The structure does not differ from MSDE or a greater version of SQL Server 2k. use the kb article here to go the offical way.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-my-msde-database-to-full-blown-sql-server-2000.html a good one.