meta user
network profile
| bio | website | |
|---|---|---|
| location | Ohio | |
| age | 31 | |
| visits | member for | 1 year, 8 months |
| seen | yesterday | |
| stats | profile views | 4 |
I work on e-commerce web apps. ASP.NET is my specialty and I dabble in Endeca.
|
Sep 10 |
awarded | Scholar |
|
Sep 10 |
accepted | Can a database file be brought back online if the file is recovered from a disk backup? |
|
Sep 10 |
comment |
Can a database file be brought back online if the file is recovered from a disk backup? Both answers sound like they would work but I don't think we actually have a proper SQL Server Backup. I'm going to accept your answer Mark because it was first. |
|
Sep 10 |
comment |
Can a database file be brought back online if the file is recovered from a disk backup? It's not mission critical data and won't really cause any problems. No real data was "lost" because it was just cleanup. Just leaves a bad taste in my mouth because there's a bit of extra junk laying around. |
|
Sep 9 |
comment |
Can a database file be brought back online if the file is recovered from a disk backup? To my knowledge, we don't take SQL Server backups of this particular server because we don't have the disk space. I am not in charge of backups but I do know that BackupExec is used to do full disk backups once a week. |
|
Sep 9 |
comment |
Can a database file be brought back online if the file is recovered from a disk backup? This seems pretty reasonable. I think both your solution and Marks are not very difficult and probably the safest for database integrity. Does it make a difference that we only keep a disk backup and not an actual SQL Server backup of the data drive? Would that make it more or less difficult (or even impossible)? |
|
Sep 8 |
comment |
Can a database file be brought back online if the file is recovered from a disk backup? I was afraid that was the case from my failed attempts to bring them back and my previous Google searches. I am more than hesitant to hack through the sys.master_files to change state because that's just bad news. I'll look at rebuilding the database if the business case is there, but it may become a rainy day project as the time involved would outweigh the benefit for this particular database. |
|
Sep 8 |
awarded | Analytical |
|
Sep 8 |
awarded | Student |
|
Sep 8 |
asked | Can a database file be brought back online if the file is recovered from a disk backup? |
