Backing up to a UNC patch
HiI am trying to get a full and differential backup to go to a unc path. I can get it running locally so if you can help that would be great.The user I am logged on as has read write access.Here is the backup log file.FQDN and other sensitive info has been XXXXXXX outThanks
[6/26/2009 12:57:03 PM]: Verbose: Using directory: \\XXXXXXX.local\SharePointFull\spbr0001\.
[6/26/2009 12:57:03 PM]: Verbose: The backup/restore process included the following objects:
[6/26/2009 12:57:03 PM]: Farm\
[SharePoint_Config]\
Windows SharePoint Services Web Application\
SharePoint - 80\
WSS_Content\
[WSS_Administration]\
[Web Application]\
SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883\
Windows SharePoint Services Search\
[Search instance]\
[WSS_Search_Server]\
[6/26/2009 12:57:03 PM]: Progress: Starting Backup.
[6/26/2009 12:57:03 PM]: Start Time: 6/26/2009 12:57:03 PM.
[6/26/2009 12:57:03 PM]: Verbose: Requested by XXXXXXXXX.
[6/26/2009 12:57:03 PM]: Verbose: Backup/Restore Settings:
Backup
Backup Method: Full
Top Component:
Directory: \\DFS-server1.tall.local\SharePointFull
Progress updated: 5
[6/26/2009 12:57:03 PM]: Backup threads created: 1
[6/26/2009 12:57:03 PM]: Verbose: Adding Farm to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Adding SharePoint_Config to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Adding Windows SharePoint Services Web Application to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Adding SharePoint - 80 to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Adding WSS_Content to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Adding WSS_Administration to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Adding Web Application to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Adding SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883 to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Adding Windows SharePoint Services Search to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Adding Search instance to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Adding WSS_Search_SQL-Server1 to Backup list.
[6/26/2009 12:57:03 PM]: Verbose: Starting OnPrepareBackup event.
[6/26/2009 12:57:03 PM]: Verbose: Starting object: Farm.
[6/26/2009 12:57:03 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:03 PM]: Verbose: Starting object: SharePoint_Config.
[6/26/2009 12:57:03 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:03 PM]: Verbose: Starting object: Windows SharePoint Services Web Application.
[6/26/2009 12:57:03 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:03 PM]: Verbose: Starting object: SharePoint - 80.
[6/26/2009 12:57:03 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:04 PM]: Verbose: Starting object: WSS_Content.
[6/26/2009 12:57:04 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:04 PM]: Verbose: Starting object: WSS_Administration.
[6/26/2009 12:57:04 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:04 PM]: Verbose: Starting object: Web Application.
[6/26/2009 12:57:04 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:04 PM]: Verbose: Starting object: SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883.
[6/26/2009 12:57:04 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:04 PM]: Verbose: Starting object: Windows SharePoint Services Search.
[6/26/2009 12:57:04 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:04 PM]: Verbose: Starting object: Search instance.
[6/26/2009 12:57:04 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:04 PM]: Verbose: Starting object: WSS_Search_SQL-Server1.
[6/26/2009 12:57:04 PM]: Verbose: Saving SPPersistedObject State
[6/26/2009 12:57:04 PM]: Verbose: Starting OnBackup event.
[26/06/2009 12:57:04]: Verbose: Starting object: Farm.
[26/06/2009 12:57:04]: Progress: [Farm] 50 percent complete.
[26/06/2009 12:57:04]: Verbose: Starting object: SharePoint_Config.
[26/06/2009 12:57:04]: Verbose: [SharePoint_Config] SQL Server Connection String: Data Source=SQL-Server1\SharePoint;Initial Catalog=SharePoint_Config;Integrated Security=True;Enlist=False.
[26/06/2009 12:57:04]: Verbose: [SharePoint_Config] SQL command started at: 26/06/2009 12:57:04. This command may take a while to complete and without notification.
[26/06/2009 12:57:04]: Verbose: [SharePoint_Config] SQL Server Command: BACKUP DATABASE [SharePoint_Config] TO DISK=@db_loc WITH NAME=@db_name, STATS=5, NOINIT, NOSKIP, NOFORMAT, NOREWIND
@db_name=SharePoint_Config, @db_loc=\\DFS-server1.tall.local\SharePointFull\spbr0001\0000000C.bak
[26/06/2009 12:57:04]: Error: Object SharePoint_Config failed in event OnBackup. For more information, see the error log located in the backup directory.
SqlException: Cannot open backup device '\\DFS-server1.tall.local\SharePointFull\spbr0001\0000000C.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
BACKUP DATABASE is terminating abnormally.
[26/06/2009 12:57:04]: Debug: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.RunCommand(SPBackupRestoreInformation args, Boolean& restart, SPSqlBackupRestoreConnection connection)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.SPDatabase.OnBackup(Object sender, SPBackupInformation info)
[26/06/2009 12:57:04]: Verbose: Starting object: Windows SharePoint Services Web Application.
[26/06/2009 12:57:04]: Progress: [Windows SharePoint Services Web Application] 50 percent complete.
[26/06/2009 12:57:04]: Verbose: Starting object: SharePoint - 80.
[26/06/2009 12:57:04]: Progress: [SharePoint - 80] 50 percent complete.
[26/06/2009 12:57:04]: Verbose: Starting object: WSS_Content.
[26/06/2009 12:57:04]: Verbose: [WSS_Content] SQL Server Connection String: Data Source=SQL-Server1\SharePoint;Initial Catalog=WSS_Content;Integrated Security=True;Enlist=False;Connect Timeout=15.
[26/06/2009 12:57:04]: Verbose: [WSS_Content] SQL command started at: 26/06/2009 12:57:04. This command may take a while to complete and without notification.
[26/06/2009 12:57:04]: Verbose: [WSS_Content] SQL Server Command: BACKUP DATABASE [WSS_Content] TO DISK=@db_loc WITH NAME=@db_name, STATS=5, NOINIT, NOSKIP, NOFORMAT, NOREWIND
@db_name=WSS_Content, @db_loc=\\XXXXXXX.local\SharePointFull\spbr0001\0000000E.bak
[26/06/2009 12:57:04]: Error: Object WSS_Content failed in event OnBackup. For more information, see the error log located in the backup directory.
SqlException: Cannot open backup device '\\XXXXXXX.local\SharePointFull\spbr0001\0000000E.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
BACKUP DATABASE is terminating abnormally.
[26/06/2009 12:57:04]: Debug: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.RunCommand(SPBackupRestoreInformation args, Boolean& restart, SPSqlBackupRestoreConnection connection)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.SPDatabase.OnBackup(Object sender, SPBackupInformation info)
[26/06/2009 12:57:04]: Verbose: Starting object: WSS_Administration.
[26/06/2009 12:57:04]: Progress: [WSS_Administration] 50 percent complete.
[26/06/2009 12:57:04]: Verbose: Starting object: Web Application.
[26/06/2009 12:57:05]: Progress: [Web Application] 50 percent complete.
[26/06/2009 12:57:05]: Verbose: Starting object: SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883.
[26/06/2009 12:57:05]: Verbose: [SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883] SQL Server Connection String: Data Source=SQL-Server1\SharePoint;Initial Catalog=SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883;Integrated Security=True;Enlist=False;Connect Timeout=15.
[26/06/2009 12:57:05]: Verbose: [SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883] SQL command started at: 26/06/2009 12:57:05. This command may take a while to complete and without notification.
[26/06/2009 12:57:05]: Verbose: [SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883] SQL Server Command: BACKUP DATABASE [SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883] TO DISK=@db_loc WITH NAME=@db_name, STATS=5, NOINIT, NOSKIP, NOFORMAT, NOREWIND
@db_name=SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883, @db_loc=\\XXXXXXXXXX.local\SharePointFull\spbr0001\00000010.bak
[26/06/2009 12:57:05]: Error: Object SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883 failed in event OnBackup. For more information, see the error log located in the backup directory.
SqlException: Cannot open backup device '\\XXXXXXXXXX.local\SharePointFull\spbr0001\00000010.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
BACKUP DATABASE is terminating abnormally.
[26/06/2009 12:57:05]: Debug: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.RunCommand(SPBackupRestoreInformation args, Boolean& restart, SPSqlBackupRestoreConnection connection)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.SPDatabase.OnBackup(Object sender, SPBackupInformation info)
[26/06/2009 12:57:05]: Verbose: Starting object: Windows SharePoint Services Search.
[26/06/2009 12:57:05]: Progress: [Windows SharePoint Services Search] 50 percent complete.
[26/06/2009 12:57:05]: Verbose: Starting object: Search instance.
[26/06/2009 12:57:05]: Progress: [Search instance] 50 percent complete.
[26/06/2009 12:57:30]: Verbose: Starting object: WSS_Search_Server.
[26/06/2009 12:57:30]: Verbose: [WSS_Search_SQL-Server1] SQL Server Connection String: Data Source=SQL-Server1\SharePoint;Initial Catalog=WSS_Search_XXXXXXX;Integrated Security=True;Enlist=False;Connect Timeout=15.
[26/06/2009 12:57:30]: Verbose: [WSS_Search_Server] SQL command started at: 26/06/2009 12:57:30. This command may take a while to complete and without notification.
[26/06/2009 12:57:30]: Verbose: [WSS_Search_SQL-Server1] SQL Server Command: BACKUP DATABASE [WSS_Search_SQL-Server1] TO DISK=@db_loc WITH NAME=@db_name, STATS=5, NOINIT, NOSKIP, NOFORMAT, NOREWIND
@db_name=WSS_Search_SQL-Server1, @db_loc=\\XXXXXXx.local\SharePointFull\spbr0001\00000011.bak
[26/06/2009 12:57:30]: Error: Object WSS_Search_SQL-Server1 failed in event OnBackup. For more information, see the error log located in the backup directory.
SqlException: Cannot open backup device '\\XXXXXX.local\SharePointFull\spbr0001\00000011.bak'. Operating system error 5(failed to retrieve text for this error. Reason: 15105).
BACKUP DATABASE is terminating abnormally.
[26/06/2009 12:57:30]: Debug: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.RunCommand(SPBackupRestoreInformation args, Boolean& restart, SPSqlBackupRestoreConnection connection)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupRestoreHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.Backup.SPSqlBackupHelper.Run(SPBackupRestoreInformation args)
at Microsoft.SharePoint.Administration.SPDatabase.OnBackup(Object sender, SPBackupInformation info)
[6/26/2009 12:57:30 PM]: Verbose: Starting OnBackupComplete event.
[26/06/2009 12:57:30]: Verbose: Starting object: Farm.
[26/06/2009 12:57:30]: Progress: [Farm] 100 percent complete.
[26/06/2009 12:57:30]: Verbose: Starting object: SharePoint_Config.
[26/06/2009 12:57:30]: Verbose: Starting object: Windows SharePoint Services Web Application.
[26/06/2009 12:57:30]: Progress: [Windows SharePoint Services Web Application] 100 percent complete.
[26/06/2009 12:57:30]: Verbose: Starting object: SharePoint - 80.
[26/06/2009 12:57:30]: Progress: [SharePoint - 80] 100 percent complete.
[26/06/2009 12:57:30]: Verbose: Starting object: WSS_Content.
[26/06/2009 12:57:31]: Verbose: Starting object: WSS_Administration.
[26/06/2009 12:57:31]: Progress: [WSS_Administration] 100 percent complete.
[26/06/2009 12:57:31]: Verbose: Starting object: Web Application.
[26/06/2009 12:57:31]: Progress: [Web Application] 100 percent complete.
[26/06/2009 12:57:31]: Verbose: Starting object: SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883.
[26/06/2009 12:57:31]: Verbose: Starting object: Windows SharePoint Services Search.
[26/06/2009 12:57:31]: Progress: [Windows SharePoint Services Search] 100 percent complete.
[26/06/2009 12:57:31]: Verbose: Starting object: Search instance.
[26/06/2009 12:57:38]: Progress: [Search instance] 100 percent complete.
[26/06/2009 12:57:38]: Verbose: Starting object: WSS_Search_SQL-Server1.
[6/26/2009 12:57:38 PM]: Finish Time: 6/26/2009 12:57:38 PM.
[6/26/2009 12:57:38 PM]: Progress: Completed with errors, please refer to the log file for details.
[6/26/2009 12:57:38 PM]: Verbose: Deleting the file \\XXXXXX.local\SharePointFull\spbr0001\spbackup.xml and replacing it.
[6/26/2009 12:57:38 PM]: Verbose: The backup/restore process included the following objects:
[6/26/2009 12:57:38 PM]: Farm\
*[SharePoint_Config]\
Windows SharePoint Services Web Application\
SharePoint - 80\
*WSS_Content\
[WSS_Administration]\
[Web Application]\
*SharePoint_AdminContent_c6084ae9-a684-4246-ad45-1554301ee883\
Windows SharePoint Services Search\
[Search instance]\
*[WSS_Search_-Server]\
[6/26/2009 12:57:38 PM]: Completed with 0 warnings.
[6/26/2009 12:57:38 PM]: Completed with 4 errors.
[6/26/2009 12:57:38 PM]: Error: Backup failed for Object WSS_Search_SQL-Server1 failed in event OnBackup. For more information, see the error log located in the backup directory.
[6/26/2009 12:57:38 PM]: -------------------------------------------------
June 26th, 2009 3:11pm
Sorry for the late reply.Thanks your Advise was very helpful
Free Windows Admin Tool Kit Click here and download it now
July 3rd, 2009 3:28pm
Please change according to the below link
http://urenjoy.blogspot.com/2008/12/cannot-open-backup-device-sql-server.html
No need to give read, write permissions to give for users.
Thanks
Harish
April 22nd, 2010 8:13am
I still had the problem with both the Admin and SQL account having read/write access to the share and Everyone set to Full Control.
I then read "Only a member of the Farm Administrators group can take a backup using Central Administration. Also you need to have Full Control on the shared given to the SQL Server service's account, SharePoint 2010 Timer Service and Central Administration's
application pool identity account." [http://www.mssharepointtips.com/tip.asp?id=1040&page=4].
It now works.
Not tested it with Everyone having only Change rights yet.
Free Windows Admin Tool Kit Click here and download it now
April 11th, 2011 11:52am