You've heard of "the accidental DBA", right? Well, I'm the accidental TFS admin. I have a bit more knowledge of TFS, than the average developer, ergo when the former TFS admin left, I got stuck with it.
But my question is more about SQL Server, than TFS. Our TFS backups haven't worked in over a week. I've stumbled upon (literally, because no one bothered to show it to me) the TFS Management console, where I found that TFS is backing up the SQL Server database to a separate server. (The TFS database is on one server, the backups on another.) However, I have no privileges on the backup server beyond being able to remote to it.
The backups had been going to one hard drive, but it's nearly full. I asked that the share pointing to the drive be changed to point to another drive, with more space. I think it's done, as I'm now seeing .log files in the new drive. But the backups still aren't happening. There's errors like this:
[8/6/2020 8:00:01 AM] [Info] Taking Full Backup. Server: DOHR2SIMTFS009, Database: Tfs_DefaultCollection Filename: \\OURSERVER\TFS Backups\Tfs_DefaultCollection_9860695012869736624F.bak
[8/6/2020 8:00:01 AM] [Info] BACKUP DATABASE [Tfs_DefaultCollection] TO DISK = N'\\OURSERVER\TFS Backups\Tfs_DefaultCollection_9860695012869736624F.bak' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, STATS = 10
[8/6/2020 8:00:01 AM] [Error]
What would be causing these errors?
- This topic was modified 1 month, 2 weeks ago by Rod at work. Reason: corrected grammer
Kindest Regards, Rod Connect with me on LinkedIn.