Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 9708 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Having trouble backing up Sophos database using backupdb.bat

AndyH2014

Hi,

So basically I'm trying to backup my database to another location on the same server (usb drive) and it keeps failing.

My database location is: C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\SOPHOS50_log_LDF

And I want to back it up to: E:\Sophos\ (which is the usb drive)

I am using the following command: 

backupdb.bat e:\sophos "C:\Program Files\Microsoft SQL Server\MSSQL$SOPHOS\Data\SOPHOS50_log.LDF" SOPHOS50

And getting ths following error: 

C:\Program Files\Sophos\Enterprise Console\DB\Core>SET backupFilePath=C:\e:\soph
os
files\microsoft was unexpected at this time.

C:\Program Files\Sophos\Enterprise Console\DB\Core>@IF ""c:\program files\micros
oft sql server\mssql$sophos\data\sophos50_log.ldf"" == "" SET instanceName=LVNAS
02\SOPHOS

Any help would be much appreciated.

Regards.

:53317


This thread was automatically locked due to age.
Parents
  • 0

    Thanks Jak.

    That has worked, however it has backed up the SOPHOS50.mdf file rather than the SOPHOS50_log.LDF file.

    Basically what I am trying to do is shrink the SOPHOS50_log.LDF file (which is currently 28GB).  Reading online it says to back it up and then switch the recovery model from 'Full' to 'Simple' in SQL Management Studio.  I backed it up (mdf file) and then changed the recovery model, then backed it up again.  However, the log file doesn't appear to have shrunk.

    Any further advice would be much apprectiated.

    Regards

    :53333
Reply
  • 0

    Thanks Jak.

    That has worked, however it has backed up the SOPHOS50.mdf file rather than the SOPHOS50_log.LDF file.

    Basically what I am trying to do is shrink the SOPHOS50_log.LDF file (which is currently 28GB).  Reading online it says to back it up and then switch the recovery model from 'Full' to 'Simple' in SQL Management Studio.  I backed it up (mdf file) and then changed the recovery model, then backed it up again.  However, the log file doesn't appear to have shrunk.

    Any further advice would be much apprectiated.

    Regards

    :53333
Children
No Data