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 |
|
bigbeehive
Starting Member
2 Posts |
 Posted - 2011-01-13 : 12:09:04
|
| Scenario: A Win XP Pro SP3 computer with MSDE and an application-specific database. MSDE was installed during the install of the application. WHS v1 (Windows Home Server v1) is used to backup the C: drive of this system - the C: drive being the location of everything (OS, MSDE, database, application, etc.) every night.Situation: The C: drive of this system goes bad, so it is replaced with a new one of like size and a WHS v1 Restore is done to replenish the contents of the C: drive's last backup to the new HDD.Question: Will MSDE and the application-specific database function without problems? The question is really about MSDE and its database, and the fact that everything now resides on a different HDD. I could test this to get the answer, if nobody has tried this scenario before, but I thought I'd ask first. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bigbeehive
Starting Member
2 Posts |
Posted - 2011-01-13 : 12:23:24
|
quote:
Originally posted by tkizer
It will likely work, however there could be some issues with it. You should backup the databases via SQL Server to files, and then WHS would backup those files. If restoring the drive doesn't work for SQL Server, then you could restore the databases using the SQL Server backup files.Do not solely rely on file backups. You need SQL Server backups too.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Tara, thanks for your advice... Sounds like a "Best Practice" suggestion. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-01-13 : 14:09:18
|
quote:
Originally posted by bigbeehive
quote:
Originally posted by tkizer
It will likely work, however there could be some issues with it. You should backup the databases via SQL Server to files, and then WHS would backup those files. If restoring the drive doesn't work for SQL Server, then you could restore the databases using the SQL Server backup files.Do not solely rely on file backups. You need SQL Server backups too.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Tara, thanks for your advice... Sounds like a "Best Practice" suggestion.
It's more of a "Practice That Actually Works" suggestion.  CODO ERGO SUM |
|
|
|
|
|
|
|
|
MSDE Database and WHS Backup/Restore