Home Forums SQL Server 2008 SQL Server 2008 - General Backup SQL 2008 Small DB-Need Profesional Help RE: Backup SQL 2008 Small DB-Need Profesional Help
drnorbert
SSC-Addicted
Points: 420
More actions
June 15, 2013 at 3:44 pm
#1624394
SELECT name
FROM master.sys.databases
WHERE recovery_model_desc != 'SIMPLE'
Results:
model
ReportServer
DATA2007
ISMDATA
Users are changing and or adding an average of 100 records. Shall I still backup the log every hour?