Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2005
    Location
    Denver, CO
    Posts
    100

    Unanswered: Export Empty Database

    This is kind of a elementary question, but how do you export an empty copy of a SQL 2005 database to a backup file? Basically I need a backup without any of the data. Thanks!

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    what you want is just the scripts for the objects then.

    you can use GSW for this, or this console app: http://www.codeplex.com/scriptdb

  3. #3
    Join Date
    Jun 2005
    Location
    Denver, CO
    Posts
    100
    I think I already accomplished this using SQL Management Studio. Is that all I need?
    BillS

  4. #4
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    yea, that works. that's what I meant by GSW - "generate scripts wizard" in ssms.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •