I have a backup of a very big database. What I want is to restore this database, but there is not enough space on my harddisk. Since I don't need the data, is there a way to restore it without the data?
I've already tried to script the schema etc. but when I run the script, it doesn't work unfortunately.
Thanks in advance
Use the Generate and Publish Scripts Wizard to create a Transact-SQL script for many objects. The wizard generates a script of all the objects in a database, or a subset of the objects that you select. The wizard has many options for your scripts, such as whether to include permissions, collation, constraints, and so on.
check here how to generate script- SQL Server 2012 copy database without data
Do you have RedGate SQL Compare? If I only had a database backup available, I would run SQL Compare using the backup as source, and a brand new database as the target. The results of the compare should give you what you need, in the correct order of deployment.
