13 reputation
3
bio website
location Ohio
age 32
visits member for 2 years, 11 months
seen Apr 1 at 16:18

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?