What are the challenges you face when working across database platforms? Take the survey

Log shipping not enough space on drive

smaddensmadden Posts: 2
edited May 13, 2010 1:38PM in SQL Backup Previous Versions
I am trying to create a new Log shipping job, but I do not have enough space on my C drive. I only have 7GB, but I need 19GB.
Any ideas how I can get SQL Backup to use the free space on another drive rather then using C, or get it to process in smaller chunks so that it does not need the full 19GB?



  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    Thank you for your post into the forum.

    I suspect that you are selecting the destination database you are choosing the option to overwrite an existing database, I am correct? If the answer is yes, then you have encounter a known bug where SQL Backup when restoring the FULL_SEED backup, will modify the file location paths for the mdf and ldf files to the default SQL Server path.

    To work around this problem, when selecting the destination database can you please select the option to create a new database. You will then be able to configure the file location paths for the mdf and ldf file to be on another drive that has sufficient free space.

    Many Thanks
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.