Is it possible to restore only the schema and stored procedures from a MS SQL database backup?
10,581
I don't think so, but you could restore it to a temporary database and then script it all from there.
Author by
B4ndt
Updated on June 08, 2022Comments
-
B4ndt about 2 years
I have a full MS SQL Backup file that I would like to extract the stored procedures and schema from. Is there a way to restore only the schema definitions and stored procedures without restoring the data/table rows?
-
B4ndt over 15 yearsI'm using SQL2005 and SQL Server Management Studio
-
B4ndt almost 11 yearsI see that, SQL Server has been able to do that for quite a few versions now. I don't think that this answer will solve the original question though.