October 25, 2024 at 3:30 pm
We are restoring a database from a full backup file of a database with two schemas. The tables on the dbo schema restore as expected, but the tables on the other schema do not appear. Trying to resolve this, we created three test tables, one on the dbo schema, one on the schema that was not in the restored database, and the third in a new schema and did a full backup on that database. The one on the dbo schema and new schema were in the restored database, but the table in the missing schema was missing.
The database does not have multiple filing groups. It's as if the schema had a property that would prevent it being part of any backup. But there's not much on schema properties.
Any ideas as to what might be going on?
October 25, 2024 at 5:57 pm
Hmm, are you using SSMS / gui to see the tables? Maybe there is a filter set for schema=dbo?
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply