SQL Backup selection on BE 12.5

[S_T_2]

HI.

I am setting up the backup to run on my SQL server.  When i make my bu directory selections, should i be backing up both \Program Files\MSSQL\DATA and Microsoft SQL Database folder or can i bypass one of those folders?

THANKS.

ST

[Ken_Putnam]

for the SQL data, you need to be backing up the Databases.

if you backup the  database folder(s), a technology called Active File Exclusion will bypass the database files and not tell you it is skipping them.  If you want to periodically get flat-file backups of your databases see

http://seer.entsupport.symantec.com/docs/259152.htm

to turn AFE off

[S_T_2]

HI KEN.

This is where i am confused... Should i be selecting the \ProgramFiles\MSSQL\Data folder and or Microsoft SQL Server folder that is listed on the selection tree?

[HiDefGator]

You should select the Microsoft SQL Server folder that is listed in your selection tree.  After the backup you will databases listed in the job log.  You will also see SQL databases in the restore view.

You can also select the "program files\microsoft sql server" folder if you want to back up the non-database files in those folders.