Forum Replies Created

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

  • RE: Zipping solutions for db size of 5gb

    Use sqlzip to do the backup, it will compress the backup on the fly. A 5gb backup file will be around 400mb when done. Sqlzip is also faster on the...


    Bill Stevenson
    MCSE, MCDBA

  • RE: Backup time increased

    Try sqlzip. http://www.sqlzip.com

    Backup local then copy across the network. Sqlzip will compress the backups on the fly instead of laying the files down and then compressing them. I...


    Bill Stevenson
    MCSE, MCDBA

  • RE: xp_sqlagent_proxy_account - user can not login

    I am having the same issue. I have tried several accounts even my own, all come up with the same error. I know that these account can log in. Is...


    Bill Stevenson
    MCSE, MCDBA

  • RE: Error in SQL backup & restore script

    The paths should be valid.If I run sp_helpdb for Northwind I get the following:

    Northwind, 1, C:\MSSQL\DATA\northwnd.mdf, PRIMARY, 4864 KB, Unlimited, 10%, data only

    Northwind_log, 2, C:\MSSQL7\DATA\northwnd.ldf, NULL, 1024 KB, Unlimited, 10%,...


    Bill Stevenson
    MCSE, MCDBA

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