Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Paths not found, MinionBackup 1.3 on Windows Server 2016

DizzyBadger Apr 01, 2017 01:42PM CDT

I was trying out v 1.3 on one of my servers but I just could not get it working. I installed a new test VM in my lab to see if it was something to do with the machine, but I get the same results: Backups are not created.
I used the generate statements option to test the commands directly. The backup statement is generated as expected, and it also runs perfectly provided I create the path manually. Otherwise it fails with error 3, path not found. MinionBackup appears to be unable to create folders for some reason. I am not able to find any error messages, but I may not be looking for them in the right place.

Version 1.2 works fine on both servers by the way.

OS: Windows 2016 with GUI
SQL: 2016 SP1

Up 0 rated Down
Sean McCown Apr 03, 2017 10:59AM CDT MinionWare Agent

Interesting stuff! Can you send me some information to help troubleshoot?
– Contents of Minion.BackupSettings
– Contents of Minion.BackupSettingsPath
– Contents of Minion.BackupSettingsServer
– Contents of Minion.BackupTuningThresholds
– The Minion.BackupMaster statement you’re using
– The BACKUP DATABASE statements generated when you use @stmtOnly=1
And we’ll go from there! Thanks,
Jen

Up 0 rated Down
Sean McCown Apr 04, 2017 03:13PM CDT MinionWare Agent

Hi,

What happens if you run the BackupDB statement with StmtOnly = 0?

EXEC Minion.BackupDB @DBName = ‘Minions’, @BackupType = ‘Full’, @StmtOnly = 0;
GO

You can do this and send me either a new backup, or just the output from the log and logdetails tables. Thanks!

Up 0 rated Down
DizzyBadger Apr 04, 2017 03:46PM CDT
Thanks

Link to a backup of the db where Minionbackup is installed in my lab: https://www.dropbox.com/s/t9zmj4x5o9sa52c/Minions.bak?dl=0

Statements:
EXEC Minion.BackupMaster @DBType = 'User'
, @BackupType = 'Full'
, @StmtOnly = 1
, @ReadOnly = 1
,@Include = 'Minions';

EXEC Minion.BackupDB @DBName = 'Minions', @BackupType = 'Full', @StmtOnly = 1
GO

BACKUP DATABASE [Minions] TO DISK = 'S:\Backup01\Minions\Full-Minions20170404-224502.BAK' WITH CHECKSUM , INIT , FORMAT


S:\Backup01 is the default backup folder for the instance.


Kind Regards
JK
Up 0 rated Down
DizzyBadger Apr 04, 2017 03:55PM CDT
Hopefully this is readable :)

Kind Regards
JK

Result from running EXEC Minion.BackupDB @DBName = ‘Minions’, @BackupType = ‘Full’, @StmtOnly = 0;
GO

Command(s) completed successfully.

But no backup file is created.

Select * from Minion.BackupLog where ExecutionDateTime > '2017-04-04 22:00:00'
19 2017-04-04 22:30:00.857 All Complete User Log 0 1 0 NULL 1 2017-04-04 22:30:01.247 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
20 2017-04-04 22:44:30.480 All Complete NULL NULL 1 NULL NULL NULL 1 2017-04-04 22:44:30.603 0 NULL NULL NULL NULL NULL NULL NULL NULL Minions NULL NULL NULL NULL

Select * from Minion.BackupLogDetails where ExecutionDateTime > '2017-04-04 22:00:00'
5 2017-04-04 22:47:46.187 FATAL ERROR: The command object was NULL. This is an unusual situation; contact support. If you wish to troubleshoot on your own, this error was probably caused by the @TotalCMD variable being NULL when the backup was run. 0 Minions SQL01\TEST SQL01 0 0 0 User Full 2017-04-04 22:47:52.100 2017-04-04 22:47:52.243 0 NULL BACKUP DATABASE [Minions] TO DISK = 'S:\Backup01\Minions\Full-Minions20170404-224750.BAK' WITH CHECKSUM , INIT , FORMAT NULL 0 NULL NULL NULL 1 0 0 NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Local 60 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 1 1 0 NULL NULL NULL NULL NULL NULL NULL 0 0 0 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL DISK = 'S:\Backup01\Minions\Full-Minions20170404-224750.BAK' 0 NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL
6 2017-04-04 22:51:15.213 FATAL ERROR: The command object was NULL. This is an unusual situation; contact support. If you wish to troubleshoot on your own, this error was probably caused by the @TotalCMD variable being NULL when the backup was run. 0 Minions SQL01\TEST SQL01 0 0 0 User Full 2017-04-04 22:51:21.010 2017-04-04 22:51:21.070 0 NULL BACKUP DATABASE [Minions] TO DISK = 'S:\Backup01\Minions\Full-Minions20170404-225119.BAK' WITH CHECKSUM , INIT , FORMAT NULL 0 NULL NULL NULL 1 0 0 NULL NULL NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Local 60 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 1 1 1 0 NULL NULL NULL NULL NULL NULL NULL 0 0 0 1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL DISK = 'S:\Backup01\Minions\Full-Minions20170404-225119.BAK' 0 NULL NULL 0 NULL NULL NULL NULL NULL NULL NULL
Up 0 rated Down
Sean McCown Apr 04, 2017 04:55PM CDT MinionWare Agent

Awesome, it says your TotalCmd is coming up NULL, so we’ll dig into that. Next step, run the attached file – ClientMB_Test2.sql, please ignore the other two files – anyway, run that IN your Minion Backup database! to create a new, temporary stored procedure. Then run this and send me what it spits out (likely, about 4 result sets):

EXEC Minion.[BackupDB_test] DBType = 'User' , @BackupType = 'Full' , @StmtOnly = 0 , @ReadOnly = 1 ,Include = ‘Minions’;

Up -1 rated Down
DizzyBadger Apr 06, 2017 03:09PM CDT
Sadly, it would seem that I am unable to receive emails from you. I have used an alternate email address in this post. If you could please try to send me the attached file mentioned above to this address, or perhaps provide a download link? Or is there a download link I am missing?
Up 0 rated Down
Sean McCown Apr 10, 2017 10:27AM CDT MinionWare Agent

Hi,

I sent the attachment to the other address last Thursday. Did you receive?
Thanks,
Jen


Hi,

This is what I sent before:

Awesome, it says your TotalCmd is coming up NULL, so we’ll dig into that. Next step, run the attached file – ClientMB_Test2.sql, please ignore the other two files – anyway, run that IN your Minion Backup database! to create a new, temporary stored procedure. Then run this and send me what it spits out (likely, about 4 result sets):
EXEC Minion.[BackupDB_test] DBType = ‘User’ , @BackupType = ‘Full’ , @StmtOnly = 0 , @ReadOnly = 1 ,Include = ‘Minions’;

-Jen

Ref: https://minionware.desk.com/agent/case/381

Jen McCown, SQL Server Certified Master
CEO, MinionWare LLC | www.MinionWare.net

Work like a DBA

Up 0 rated Down
DizzyBadger Apr 10, 2017 01:57PM CDT
Hi!

Yes, I got it. I take it my response did not reach you? Copy inserted below.

From: Jan Kåre Lokna
Sent: fredag 7. april 2017 14.02
To: 'Jen McCown'
Subject: RE: MinionWare case 381

Hi,

Thank you for all your help 

I ran the attached script to create the procedure. The command included did not work due to invalid parameters, but looking at the procedure I tried this one instead:

EXEC Minion.[BackupDB_test] @BackupType = 'Full' , @StmtOnly = 0 , @DBName = 'Minions';

It produced the following results:

ID ServerLabel NETBIOSName Command BackupDrive BackupPath BackupLocType FullPath FullFileName FileName DateLogic Extension MainFileList MirrorFileList IsMirror RetHrs PathOrder FileNumber Buffercount MaxTransferSize NumberOfFiles Compression MirrorBackup DynamicTuning EncryptBackup BackupName ExpireDateInHrs Descr RetainDays IsChecksum BlockSize IsInit IsFormat IsCopyOnly IsSkip BackupErrorMgmt MediaName MediaDescription CertName EncrAlgorithm ThumbPrint
1 SQL01\TEST SQL01 BACKUP DATABASE [Minions] TO DISK = 'S:\Backup01\Minions\Full-Minions20170407-132132.BAK' WITH CHECKSUM , INIT , FORMAT S:\ Backup01\Minions\ Local S:\Backup01\Minions\ S:\Backup01\Minions\Full-Minions20170407-132132.BAK Full-Minions20170407-132132.BAK 20170407132131 .BAK DISK = 'S:\Backup01\Minions\Full-Minions20170407-132132.BAK' NULL 0 168 0 1 0 0 1 NULL 0 1 0 NULL 0 NULL 0 1 0 1 1 NULL NULL NULL NULL NULL NULL NULL NULL

BackupCmd
BACKUP DATABASE [Minions] TO DISK = 'S:\Backup01\Minions\Full-Minions20170407-132132.BAK' WITH CHECKSUM , INIT , FORMAT

PreCMD ServeRInstance Port TotalCmd BackupCmd
NULL .\TEST NULL NULL BACKUP DATABASE [Minions] TO DISK = 'S:\Backup01\Minions\Full-Minions20170407-132132.BAK' WITH CHECKSUM , INIT , FORMAT

Up 0 rated Down
Sean McCown May 03, 2017 10:28AM CDT MinionWare Agent

Hi,

My apologies for letting this rest for so long!

Let’s try something else that’s simple. In your Minion.BackupSettings table, would you set the Port column equal to whatever port your SQL Server instance uses? (Default is, of course, 1433.) I’m seriously starting to think that it’s an internal issue where we’re not handling a NULL port under very specific circumstances.

-Jen

Up 0 rated Down
DizzyBadger May 08, 2017 07:16AM CDT
Hi,

Port is set to 1433 in backupsettings, so is the port in SQL Server. Dynamic ports are off, and the server is set to listen all. I tried turning off the firewall just to test it, no change.
Tried disabling ipv6, no change.

PreCMD ServeRInstance Port TotalCmd BackupCmd
NULL .\TEST NULL NULL BACKUP DATABASE [Minions] TO DISK = 'S:\Backup01\Minions\Full-Minions20170508-141343.BAK' WITH CHECKSUM , INIT , FORMAT
Up 0 rated Down
Sean McCown May 08, 2017 08:58AM CDT MinionWare Agent

Set the port to NULL in BackupSettings and see what that does. I’d like you to send me the same resultset you just sent from this new run. We’ll get to the bottom of this, don’t worry.

Up 0 rated Down
Sean McCown May 09, 2017 11:49AM CDT MinionWare Agent

I think Sean’s right. I was able to reproduce the issue by using Port = 1433 on a named instance (named instances generally don’t use 1433). Try setting Port to NULL, and see if it works. -Jen

Up 0 rated Down
DizzyBadger May 09, 2017 07:05PM CDT
I can confirm that it works in my lab with port set to null. Thanks a lot for your help, now I can start playing with MinionBackup 3 :)

Resultset below

BackupCmd
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BACKUP DATABASE [Minions] TO DISK = 'S:\Backup01\Minions\Full-Minions20170510-020145.BAK' WITH CHECKSUM , INIT , FORMAT

PreCMD ServeRInstance Port TotalCmd BackupCmd
---------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
sqlcmd -r 1 -S".\TEST .\TEST sqlcmd -r 1 -S".\TEST" -q " DBCC TRACEON(3604,3213); BACKUP DATABASE [Minions] TO DISK = 'S:\Backup01\Minions\Full-Minions20170510-020145.BAK' WITH CHECKSUM , INIT , FORMAT " BACKUP DATABASE [Minions] TO DISK = 'S:\Backup01\Minions\Full-Minions20170510-020145.BAK' WITH CHECKSUM , INIT , FORMAT

output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NULL

Post Your Public Answer

Your name (required)
Your email address (required)
Answer (required)
556ca399015f31edc97a62de2771be1a@minionware.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete