Re: how to do backup of msde?
- From: "Andrew D. Newbould" <newsgroups@xxxxxxxxxxxxxxxxx>
- Date: Sat, 6 Aug 2005 12:52:45 +0100
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@xxxxxxxxxxxxx>, bo <bo@xxxxxxxxxxxxxxxxxxxxxxxxx> writes
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@xxxxxxxxxxxxxxxxxxxx>, pheonix1t <nothing@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx
ZAD Software Systems Web : www.zadsoft.com
-- Andrew D. Newbould E-Mail: newsgroups@xxxxxxxxxxxxxxxxx
ZAD Software Systems Web : www.zadsoft.com .
- References:
- Re: how to do backup of msde?
- From: bo
- Re: how to do backup of msde?
- Prev by Date: Re: SQL Server Service Manager
- Next by Date: How to find records that contain all words?
- Previous by thread: Re: how to do backup of msde?
- Next by thread: database attaching
- Index(es):
Relevant Pages
|
