Results 1 to 3 of 3
  1. #1
    RayMilhon is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,035

    Database Backups

    We have a job to backup all of our databases on a SQL Server 2014 System. Everytime it runs we get this error.

    Property Size is not available for Database '[master]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights.

    I'm the user that set it up and I have SA rights. Why wouldn't we be able to backup the Master DB?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,002
    I run this code to pull all the data into an XL workbook:
    Code:
    Public Sub BackupDb2XL()
    Dim vFile
    vFile = "c:\backups\FullDataBackup_" & Format(Date, "yyyymmdd") & ".xls"
    
    XportXL "tCustomers",vFile 
    XportXL "tPayments",vFile 
    XportXL "tAccts",vFile
    End Sub
    
    Public Sub XportXL(ByVal pvTbl, ByVal pvFile)
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, pvTbl, pvFile, True, pvTbl
    End Sub
    



  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    1,169

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 07-09-2019, 12:51 AM
  2. Replies: 1
    Last Post: 12-28-2017, 10:36 PM
  3. Database Backups
    By csmith in forum Access
    Replies: 5
    Last Post: 09-22-2016, 07:48 AM
  4. Replies: 2
    Last Post: 04-27-2016, 06:20 AM
  5. DELETE/KILL previous backups in specified folder
    By craig1988 in forum Modules
    Replies: 2
    Last Post: 02-12-2016, 08:33 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums