w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
When backup run on the schedule time 12am every night, It says the backup job completed successfully but I cannot see the backup file on the drive

I assume G: is a network share located on another drive? If so, 'G:' might be pointing to a different path under whatever account the SQL Server service is running under. Can you run the following command in SQL Server Management Studio (or SQLCMD.exe):

exec xp_cmdshell 'DIR "G:BackupFull Backup"';

This should show the content of the folder actually used by SQL Server when performing the backup.

© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.