| Groups | Blog | Home |
sql server msde : how to do backup of msde?
we use Protection Pilot (from McAffee), it installs a MSDE that it uses to store info about clients. so, I need to do a backup of the MSDE to send to their tech support people but their backup utility isn't working. They've tried for about 2 weeks now and it's not working. I asked the tech person about doing backup via command line and she looked into it, but it started asking for password! Neither of use knew about any MSDE passwords, so that didn't work either. I figured I'd ask here, what is a quick/easy way to do a backup of a MSDE via command line (taking into consideration I don't know what password it's asking for). I guess the sa account can be used, but how can I reset that account's password so the backups will work? thanks,
hi Dave,
[quoted text, click to view] pheonix1t wrote: > hello, > we use Protection Pilot (from McAffee), it installs a MSDE that it > uses to store info about clients. > so, I need to do a backup of the MSDE to send to their tech support > people but their backup utility isn't working. > They've tried for about 2 weeks now and it's not working. > > I asked the tech person about doing backup via command line and she > looked into it, but it started asking for password! > > Neither of use knew about any MSDE passwords, so that didn't work > either. > I figured I'd ask here, what is a quick/easy way to do a backup of a > MSDE via command line (taking into consideration I don't know what > password it's asking for). I guess the sa account can be used, but > how can I reset that account's password so the backups will work? if they did not deny access to the MSDE instance to local administrators you can log in as one of them and connect to the instance via a trusted connection, not requiring a standard SQL Server login's password... once connected (for instance via oSql.exe command line utility, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp , http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003) c:\...\osql.exe -E you get a command prompt like 1> where you can execute the backup statement as desired... -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
In message <#3qDpRkjFHA.1204@TK2MSFTNGP12.phx.gbl>, pheonix1t
<nothing@nothing.gone> writes [quoted text, click to view] >hello, >we use Protection Pilot (from McAffee), it installs a MSDE that it uses >to store info about clients. >so, I need to do a backup of the MSDE to send to their tech support >people but their backup utility isn't working. >They've tried for about 2 weeks now and it's not working. > >I asked the tech person about doing backup via command line and she >looked into it, but it started asking for password! > >Neither of use knew about any MSDE passwords, so that didn't work either. This sounds a little fishy if you ask me. The instance of MSDE they installed for use with their software must have got one or more user accounts assigned to it and these have probably been assigned passwords. At a very minimum it MUST have an "sa" user account. If your normal PC's Administrator password does not work then it would suggest MSDE is running in SQL User Only mode. This then brings the point that McAffee MUST know the passwords used when installing and configuring the installation. It is therefore more likely that they do NOT want to tell YOU (probably for very good reasons, however, if their own tools ain't working ...). [quoted text, click to view] >I figured I'd ask here, what is a quick/easy way to do a backup of a >MSDE via command line (taking into consideration I don't know what >password it's asking for). I guess the sa account can be used, but how >can I reset that account's password so the backups will work? > >thanks, > >dave One possible solution would be to use OSQL to detach their database from the instance of MSDE and then send them the MDF & LDF files (they will need both). They could then re-attach the database at their end to fix the problems. Another, slightly more risky move, would be to stop MSDE from running (ie: NET STOP [services]) and then copy the MDF and LDF files to them. Again, they will need both files. Don't forget to restart the MSDE services after the files have been copied. -- Andrew D. Newbould E-Mail: newsgroups@NOSPAMzadsoft.com
Why is it more risky to copy the files after stopping the server, rather than
after a detach. I am asking because I want to in part use this as a method for backup and restore. Periodically, I want to take copies of the mdf and log files for later attachment under a new database name - but without detaching the existing database. So since I will stop the server anyway during backup, I thought it unnecessary to go through an extra step of detach/attach of the original that still need to run after the backup. Regards Bo [quoted text, click to view] "Andrew D. Newbould" wrote:
> In message <#3qDpRkjFHA.1204@TK2MSFTNGP12.phx.gbl>, pheonix1t > <nothing@nothing.gone> writes > >hello, > >we use Protection Pilot (from McAffee), it installs a MSDE that it uses > >to store info about clients. > >so, I need to do a backup of the MSDE to send to their tech support > >people but their backup utility isn't working. > >They've tried for about 2 weeks now and it's not working. > > > >I asked the tech person about doing backup via command line and she > >looked into it, but it started asking for password! > > > >Neither of use knew about any MSDE passwords, so that didn't work either. > > This sounds a little fishy if you ask me. > > The instance of MSDE they installed for use with their software must > have got one or more user accounts assigned to it and these have > probably been assigned passwords. At a very minimum it MUST have an "sa" > user account. If your normal PC's Administrator password does not work > then it would suggest MSDE is running in SQL User Only mode. This then > brings the point that McAffee MUST know the passwords used when > installing and configuring the installation. It is therefore more likely > that they do NOT want to tell YOU (probably for very good reasons, > however, if their own tools ain't working ...). > > >I figured I'd ask here, what is a quick/easy way to do a backup of a > >MSDE via command line (taking into consideration I don't know what > >password it's asking for). I guess the sa account can be used, but how > >can I reset that account's password so the backups will work? > > > >thanks, > > > >dave > > One possible solution would be to use OSQL to detach their database from > the instance of MSDE and then send them the MDF & LDF files (they will > need both). They could then re-attach the database at their end to fix > the problems. > > Another, slightly more risky move, would be to stop MSDE from running > (ie: NET STOP [services]) and then copy the MDF and LDF files to them. > Again, they will need both files. Don't forget to restart the MSDE > services after the files have been copied. > > -- > Andrew D. Newbould E-Mail: newsgroups@NOSPAMzadsoft.com > > ZAD Software Systems Web : www.zadsoft.com
I can't give you a complete answer as there are others better suited to
explain however in general terms when you detach a database the logs files are flushed, statistics updated and completed transactions committed to the database. In other words a clean-up process is performed ready to transport the database. When you stop the server processes the clean-up routines are not performed to the extent that a detach does. The idea being the server can continue where it left off when it comes back on-line. In my experience most backup regimes involve stopping the server processes, backing up all MDF & LDF database files required and then restarting the server processes. This tends to be a faster process than scheduling backups to tape etc and causes the databases to be off-line for the shortest periods. Don't get me wrong, you can do on-line backups as well via Enterprise Manager but many DBA's I know won't trust the scheduling as it can get broken. Some backup software like Veritas can perform on-line backups as well however be careful in your choice as some only backup the DATA and not the Structure etc so in a failure situation its no good restoring data when you don't have the correct structure first. Kind Regards Andrew D. Newbould In message <F662A14E-E095-437D-BC05-0958E00BD903@microsoft.com>, bo <bo@discussions.microsoft.com> writes [quoted text, click to view] >Why is it more risky to copy the files after stopping the server, rather than >after a detach. I am asking because I want to in part use this as a method >for backup and restore. > >Periodically, I want to take copies of the mdf and log files for later >attachment under a new database name - but without detaching the existing >database. So since I will stop the server anyway during backup, I thought it >unnecessary to go through an extra step of detach/attach of the original that >still need to run after the backup. >Regards >Bo > >"Andrew D. Newbould" wrote: > >> In message <#3qDpRkjFHA.1204@TK2MSFTNGP12.phx.gbl>, pheonix1t >> <nothing@nothing.gone> writes >> >hello, >> >we use Protection Pilot (from McAffee), it installs a MSDE that it uses >> >to store info about clients. >> >so, I need to do a backup of the MSDE to send to their tech support >> >people but their backup utility isn't working. >> >They've tried for about 2 weeks now and it's not working. >> > >> >I asked the tech person about doing backup via command line and she >> >looked into it, but it started asking for password! >> > >> >Neither of use knew about any MSDE passwords, so that didn't work either. >> >> This sounds a little fishy if you ask me. >> >> The instance of MSDE they installed for use with their software must >> have got one or more user accounts assigned to it and these have >> probably been assigned passwords. At a very minimum it MUST have an "sa" >> user account. If your normal PC's Administrator password does not work >> then it would suggest MSDE is running in SQL User Only mode. This then >> brings the point that McAffee MUST know the passwords used when >> installing and configuring the installation. It is therefore more likely >> that they do NOT want to tell YOU (probably for very good reasons, >> however, if their own tools ain't working ...). >> >> >I figured I'd ask here, what is a quick/easy way to do a backup of a >> >MSDE via command line (taking into consideration I don't know what >> >password it's asking for). I guess the sa account can be used, but how >> >can I reset that account's password so the backups will work? >> > >> >thanks, >> > >> >dave >> >> One possible solution would be to use OSQL to detach their database from >> the instance of MSDE and then send them the MDF & LDF files (they will >> need both). They could then re-attach the database at their end to fix >> the problems. >> >> Another, slightly more risky move, would be to stop MSDE from running >> (ie: NET STOP [services]) and then copy the MDF and LDF files to them. >> Again, they will need both files. Don't forget to restart the MSDE >> services after the files have been copied. >> >> -- >> Andrew D. Newbould E-Mail: newsgroups@NOSPAMzadsoft.com >> >> ZAD Software Systems Web : www.zadsoft.com >> -- Andrew D. Newbould E-Mail: newsgroups@NOSPAMzadsoft.com
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |