Question : Oracle 10G Express installed on Windows 2000 Server Enterprise Edition. I am trying to automate backups and on […]
Category: Database Backup
Full or bulk-logged recovery model?
Question : My database is about 10 GB and I use full recovery model. Sometimes I have to add a […]
Database Backups vs Server Backups
Question : At my current job, I recently discovered that our MS SQL database servers had no backup devices set […]
Access denied to user ODBC, but trying to login as root
Question : I’m trying to do a backup of a MySQL database on Windows, but for some reason it’s trying […]
Maintenance plan to backup differentials hourly each to a new file name in SQL Server 2012
Question : In addition to a nightly full backup, I’d like to set up an hourly differential backup maintenance plan […]
Necessary to use a checksum on a backup and not solely the ‘verify backup’ option?
Question : If want to ensure the integrity of a backup, would it be a necessity to use a checksum […]
Shrinking log files with SMO
Question : I know I can use the following t-SQL to shrink a log file: BACKUP LOG db1 TO DISK […]
Backup Access Database Daily/Weekly
Question : We have a Microsoft Access database split into backend/frontend. What I am looking for is to be able […]
End Sub
Question : Answer :
Is it imperative that I backup my index files?
Question : I have a few different instances (SQL 2000, 2005) with indexes placed in a separate filegroup. Do i […]