Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BryanM67
Starting Member
2 Posts |
 Posted - 2005-10-01 : 22:59:33
|
| Just wondering, what software do you use to backup your MSDE database? I have to come up with a solution for backing up/restoring. Would appreciate any feedback. Thanks. |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-02 : 06:01:54
|
| I have consistently failed to get MSDN Backup Wizard to work (by pointing Enterprise Manager at the MSDN database in question). The pick list about Hours/Days/Weeks always seems to be blank and won't allow the Plan to be saved.You could schedule a simpleBACKUP MyDatabase ...command to run once a day.Is the machine the database is running on always on, or is it someones PC that they turn off at night? Might be best to run it at Lunchtime if its turned off at night.Or you could make a BATCH file that runs OSQL to launch the backup - so the user can click on an Icon that runs the batch file.Kristen |
 |
|
|
atom
Starting Member
1 Post |
Posted - 2005-11-07 : 01:56:02
|
| The "Remove files older than" dropdown being blank is due to a bug in MSDE, apparently from SP3 upwards. Despite the problem being known within Microsoft since early 2003, they seems to have conveniently excluded a fix from this from SP4... Conspiracy theorists might argue that's to push sales of the full-blown version of SQL server.Enterprise Manager expects to find a value for "BackupDirectory" at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer.Simply setting this REG_SZ value to any directory (for example, "C:\ProgramFiles\Microsoft SQL Server\MSSQL\BACKUP") should solve the problem.All credit to Dan Holt at http://www.dbforums.com/t739692.html. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-07 : 13:07:46
|
| Hi atom, Welcome to SQL Team!That's handy to know, thanks very muchKristen |
|
|
|
sweathers
Starting Member
1 Post |
Posted - 2005-11-22 : 20:11:03
|
| I have the same problem with a current MSDE installatio. That is, the dropdown for removing files is blank.Anyone found a resolution to this? It's really throwing me off.Cheers,Jim |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-25 : 02:24:59
|
| Did the solution that atom posted not work for you?Kristen |
|
|
|
|
|
|
MSDE backup