<p>I need to create a backup of a SQL Server 2005 Database that's only the structure...no records, just the schema. Is there any way to do this?</p>

<p>EDIT: I'm trying to create a backup file to use with old processes, so a script wouldn't work for my purposes, sorry</p>

[{'answer_id': 3590, 'author': 'Brandon Wood', 'author_id': 423, 'author_profile': 'https://Stackoverflow.com/users/423', 'pm_score': 1, 'selected': False, 'text': '<p>Why not just use SQL Management Studio to create a complete script of your database and the objects?</p>\n'}, {'answer_id': 3609, 'author': 'Greg Hurlman', 'author_id': 35, 'author_profile': 'https://Stackoverflow.com/users/35', 'pm_score': 5, 'selected': True, 'text': '<p>Use a 3 step process:</p>\n\n<ol>\n<li>Generate a script from the working database</li>\n<li>Create a new database from that script</li>\n<li>Create a backup of the new database</li>\n</ol>\n'}, {'answer_id': 3662, 'author': 'mauriciopastrana', 'author_id': 547, 'author_profile': 'https://Stackoverflow.com/users/547', 'pm_score': 0, 'selected': False, 'text': '<p>I make heavy use of this tool:<br>\n<a href="http://www.dswsoft.com/sqlbalance.php" rel="nofollow noreferrer">SQLBalance for MySQL</a>  </p>\n\n<p>Unfortunately; its windows only... but works like a charm to move databases around, data or no data, merge or compare.</p>\n'}, {'answer_id': 3738, 'author': 'Mark Harrison', 'author_id': 116, 'author_profile': 'https://Stackoverflow.com/users/116', 'pm_score': 0, 'selected': False, 'text': "<p>Toad for SQL Server does this nicely, if you're considering a commercial product.</p>\n"}, {'answer_id': 73465453, 'author': 'Daniel Brink', 'author_id': 141443, 'author_profile': 'https://Stackoverflow.com/users/141443', 'pm_score': 0, 'selected': False, 'text': '<p>As of SQL Server 2012 (patched), you can make a schema only clone of your database using <a href="https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-clonedatabase-transact-sql" rel="nofollow noreferrer">DBCC CLONEDATABASE</a>. Then simply backup the clone.</p>\n<pre><code>dbcc clonedatabase(Demo, Demo_Clone) with verify_clonedb;\nalter database [Demo_Clone] set read_write;\nbackup database [Demo_Clone] to disk = N\'C:\\temp\\Demo_SchemaOnly_20220821.bak\';\ndrop database [Demo_Clone];\n</code></pre>\n<p>Read more here: <a href="https://www.sqlservercentral.com/scripts/schema-only-database-backup" rel="nofollow noreferrer">Schema Only Database Backup</a></p>\n'}]
['https://Stackoverflow.com/questions/3589', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/44/']