ScottWStewart 2 Posted April 11, 2018 Share Posted April 11, 2018 Hi guys, First of all this is a stupid question: I am backing up my ESET server using this script: SQLCMD -S LOCALHOST\ERASQL -q "BACKUP DATABASE ERA_DB TO DISK = N'BACKUPFILE'" It executes fine, but I can't find the location of the backup file on the computer. Is there something I am leaving out that I can specify a location to save the backup file? Link to comment Share on other sites More sharing options...
j-gray 33 Posted April 11, 2018 Share Posted April 11, 2018 SQL default backup location is typically C:\Program Files\Microsoft SQL Server\%InstanceName%\MSSQL\Backup where %InstanceName% is the specific to your environment. You can always replace 'BACKUPFILE' with an explicit path (e.g. C:\backup\backupfile.bak) or add a file extension (e.g. BACKUPFILE.bak) and search for *.bak. HTH Link to comment Share on other sites More sharing options...
ScottWStewart 2 Posted April 12, 2018 Author Share Posted April 12, 2018 Thanks, j-gray! Link to comment Share on other sites More sharing options...
Recommended Posts