Post reply

bck backups

  • July 23, 2008 at 4:29 pm

    #125026

    Hi,

    One of our vendors has setup an SQL Server 2000 instance, which they have now handed over to me :crazy: and I have noticed that the backups are a .bck file instead of .bak. I cannot find any reference to a .bck file in books online - is this a valid file for s2k backups? Will there be any problems restoring from this file type?

    thanks....

  • July 23, 2008 at 4:55 pm

    #847451

    The backup files can have any name or extension you want. Using .bck will work fine and you won't have any issues with it.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • July 23, 2008 at 5:11 pm

    #847456

    thanks for your reply 😀

  • July 23, 2008 at 9:39 pm

    #847502

    If you are concerned that these aren't native backups you can always do a simple test:

    restore filelistonly from disk = 'C:\path\to\backup.bck'

    This doesn't kick off a restore, it just displays a list of the database and log files contained in the backup set. If this fails when you specify the correct path to the backup file it is probably not a native backup and there may be a 3rd party product involved in the backups.

  • August 7, 2008 at 4:37 am

    #854341

    check it restore verifyonly from 'disk'

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

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