how backup is taken ?????

Question

how backup is taken ?????

rk1980factor

SSCommitted

Points: 1681
More actions
July 18, 2016 at 10:40 am

#400424

i have couple of servers (symantec servers) which as sql server database ( but no db tool like ssms or anything installed on server). Also database backup is taken everynight and i see in log and drive *.bak created.
What I can't figure out is:
1) how that backup is taken. when i checked in log files, it only shows path of the backup storage but doesn't tell me how that backup is created ?
2) only thing i can think of is it is created and schedule using task scheduler since it is sql express version but i do not see any task doing that.
Is there away to find out how the back up is taken ?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

SQL Express doesn't include the SQL agent, so it isn't a database job that takes you backups.

The Symantec Backup Exec software may be taking the backups according to its schedule. Your DBA or network operations team should be able to answer whatever database backup questions you have.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Eric M Russell SSC Guru Points: 125560 More actions · Answer 2

I'm not sure if SQL Server Express Edition has the 'Default Trace' turned on by default or even if it supports event auditing in general. A google search gave no clear answer. However, if the Default Trace is turned on, then the following query may reveal past backup events with details like ApplicationName and LoginName of the process that executed them.

select TE.name as [EventName]

,v.subclass_name

,T.DatabaseName

,t.DatabaseID

,t.NTDomainName

,t.ApplicationName

,t.LoginName

,t.SPID

,t.StartTime

,t.RoleName

,t.TargetUserName

,t.TargetLoginName

,t.SessionLoginName

from sys.fn_trace_gettable(CONVERT(varchar(150), (

select top 1 f.[value]

from sys.fn_trace_getinfo(null) f

where f.property = 2

)), default) T

join sys.trace_events TE on T.EventClass = TE.trace_event_id

join sys.trace_subclass_values v on v.trace_event_id = TE.trace_event_id and v.subclass_value = t.EventSubClass

where te.name like ('%Backup%') or v.subclass_name like ('%Backup%')

https://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Eric M Russell SSC Guru Points: 125560 More actions · Answer 3

BTW, how and why were the additional URL parameters added to my above link?

Is this something new on SQLServerCentral?

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

lsalih SSCertifiable Points: 6143 More actions · Answer 4

I use windows scheduled task to perform backups using SQLCMD in one of my environment. If you are not seeing a scheduled task under Windows scheduler, search in msdb for backup command:

USE [msdb]

GO

SELECTj.job_id,

s.srvname,

j.name,

js.step_id,

js.command,

j.enabled

FROMdbo.sysjobs j

JOINdbo.sysjobsteps js

ONjs.job_id = j.job_id

JOINmaster.dbo.sysservers s

ONs.srvid = j.originating_server_id

WHEREjs.command LIKE N'%backup%'