Post reply

Scheme backups for SQL 2005 using scripts

  • February 19, 2006 at 1:39 am

    #112719

    Hi,

    I am looking for a way for Scheme backups (no data) of databases in SQl 2005 using scripts or SSIS.

    I tried to follow what the server does when I run the "Generate Script" wizard on the profiler, but it was too wild.

    Please let me know of anything,

    Thanks,

    Jessy.

  • February 21, 2006 at 3:08 am

    #622198

    "too wild"?

    A full backup includes the schema, why do you want no data?

  • February 21, 2006 at 3:21 am

    #622199

    "Too wild" mean it ran a lot of scripts which were very hard to follow.

    There are many cases where I don't need the data, or I want to save disk space.

    I need just the schema backup in scripts, and this will give me the ability to restore particular objects all a full schema on another server and so on.

  • February 21, 2006 at 4:10 am

    #622209

    I see - it is the most comprehensive way to achieve your goal though.

    You can then search the script for the particular object you want to recreate.

    Be aware that you can also use DDL triggers now to discourage object deletions with something like this:

    CREATE TRIGGER trigger_name ON ALL SERVER

    FOR DROP_TABLE, ALTER_TABLE

    AS

    PRINT 'You must disable Trigger "safety" to drop or alter tables!'

    ROLLBACK

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply