backup index

  • how to backup the sql 2008 database indexes? thanks

  • There is no backup designed for indexes only. You could script them out as a DROP - CREATE series of statements by going to the GUI though, right-clicking the database and choosing Tasks -> Generate Script.

    You have me curious, though. What prompted this question?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • laddu4700 (7/13/2012)


    how to backup the sql 2008 database indexes? thanks

    Backup your database(s) regularly and all of these objects will be backed up 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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