BACKUP RESTORE with no data

Hi champs,

Is there a way in SQL2k5 to backup and restore a database, without the data that is stored in the tables?

I know I can script the whole database, but is there do this with a backup restore?

/Many thanks

No, Backup backups up the database, data included. Otherwise it wouldn't be a backup, would it?

The easiest way is to script the database and run the scripts. I'm curious about you desire to avoid scripting...

|||

Is there any way of scripting the database out automatically?

I mean, is it possible to make a scripting backup of the database as a "Maintenance plan"?

/Many thanks

|||not as maintainance plan..... but u can create a job for it and schedule it....|||

Hi Rogvi

Is this something that you would need to do regularly and, if so, for what purpose?

Thanks
Chris

|||

The data in the database is not needed, as we are in the development mode now. I need to make regular database definition backup; the data in the database is only filling up the diskspace and is of no value.

/many thanks