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
No comments:
Post a Comment