I have a development server, with a small number of development databases on it.
Some of them can contain vast amounts of data - data which is randomly generated and of no real value.
I want to be able to backup the 'sturcture' of all the databases on the server, but not the data.
In worse-case scenario, if I lost the server, I want to be able to re-create the 'empty' databases, ie. without the data.
If I chose to perform 'normal' backups, even in the Simple Model, I will end up repeatingly backing up vast amounts of worthless data. All i want to backup is the empty databases.
Can this be done within SQL Server 2000, and/or will I need to create scripts, and/or do they already exist?
(I'm assuming I will need to perform normal backups of the master and msdb databases too.)