Post reply

Make a small backup for testing

  • September 2, 2003 at 4:41 pm

    #106582

    I need to make a full backup of a large SQL Server 2000 database but I only want a small file. Confused? We want to test some clustering we're having an outside company do and one of the databases is very large, so we want a subset of the entire database (i.e., a smaller file to work with). Any ideas if this is possible and how I would achieve this? TIA.

  • September 2, 2003 at 6:59 pm

    #472282

    If you are doing this on a regular basis.

    Invest in Litespeed.

    Biggest database we have is about 30 gig.

    With litespeed the backup is 3gig.

  • September 3, 2003 at 4:54 pm

    #472451

    This is only a one time occurrence.

  • September 3, 2003 at 5:46 pm

    #472461

    What's the size of the database?

  • September 4, 2003 at 3:13 pm

    #472682

    The database and log files are 181,546.06MB and 49.19MB respectively.

  • September 4, 2003 at 3:28 pm

    #472684

    I'll suggest that you trial SQLLitespeed, and maybe you're like it so much you could get the budget to buy it

    Edited by - steven_white40 on 09/04/2003 3:28:52 PM

    Steven

  • September 4, 2003 at 10:16 pm

    #472720

    Here here. Litespeed is a saviour!

  • September 10, 2003 at 6:01 pm

    #473589

    Can you create a test/sample database with only a portion of the data? Might run into some referential integrity issues though. If Foreign Keys aren't important for the testing then this may be a nice route.

    **You could create the test database.

    **Generate a script to create and populate the tables with only a sample of records.

    **Run the script in the test database

    **Backup the test database.

    I am not gauranteeing this will work, but here is the idea...

    SELECT 'SELECT TOP 100 * INTO ' + o.name +

    ' FROM <databasename>.' + o.name + CHAR(10) + 'GO'

    FROM sysobjects

    WHERE xtype = 'U'


    "Keep Your Stick On the Ice" ..Red Green

Viewing 8 posts - 1 through 7 (of 7 total)

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