Post reply

backup

  • May 20, 2008 at 12:27 am

    #186783

    Hello,

    can any write how write code for (backup format) using init and , code for backup table

    Regards,

    sathish.

  • May 20, 2008 at 12:41 am

    #817595

    BACKUP DATABASE [Ax_Dev] TO DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Ax_Dev.bak' WITH NOFORMAT, NOINIT, NAME = N'Ax_Dev-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10

    GO

    To Backup a table I would use:

    select * into newtable from table

    you can also create a blank clean database and then use the following:

    select * into newdb..newtable from table

    (the above will create a copy of the Table to the new database - this you can now backup as per first script after chanding the DB and file output names)

    Thanks

    Kevin

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

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