You are here

Backup

I get "Access is denied" error when I back up sql server datebase to a network shared folder.

Storage server saves backup to target shared folder , but Storage Server service is running as Local System account in default . Local System account may not have enough privileges to access the network shared folder. So you can change DataBK Storage Server service account to a new one in in Control Panel->Administrative Tools->Service , see following : (Please note that : Server that shares the folder should also has the same account name and password . )

No user database listed in sql server backup job configuration window,why?

This issue most probably because account specified in sql instance configuration window has no enough privilege to access use database.

instance account settings

Solution :

Backing up a remote SQL Server

Microsoft SQL Server dose not allow to back it up from a remote machine. You have to install a copy of DataBK Backup Agent onto your server machine and then use backup manager to configure a job to back up database to your local machine's Storge Server.
Please see the following :

I got errors while doing database consistency check , what is suggestion?

SQL Server Backup has an option to do the sql server database consistency check , see following:

You got errors indicated the potential problems in your database and should be corrected immediately , the problem may be caused by many reasons , this product can only let you know the DBCC check is failed , to get more detail information , you can run the DBCC command once again in Query Analyzer or Management Studio, command as following :

DBCC CHECKDB ('database name')

Can I mix use SQL Server backup software Microsoft SQL Server Agent in backing up a database?

No .

If you define backup jobs for same database in both backup utilties, Microsoft SQL Server dose not record the program who create backups. When you plan to restore this database , you will find you are in a complicated situation , such as, you may need a full backup created by SQL Server Agent and a differential backup created by SQL Server Backup software. It is strong recommended that you just select one SQL Server Backup utility to back up your database.

Delete SQL Server old backups automatically.

A key feature of SQL Server Backup is that it can delete expired backup automatically . This feature can save and reuse your storage space , need not worry about the storage space problem.



When a job's backup is expired, it is deleted at the end of the job . If this job dose not run, it will not be deleted.



Importance:

Creating MS SQL Server transaction log backup.

  • Transaction log backup is a backup for log files of a database .
  • Backing up the transaction log periodically to create a sequence of transaction log backups offers users the most flexibility in restoring databases.
  • By creating transaction log backups, a database can be restored to any point in time contained within the sequence of transaction logs, right up to the point of failure , because it is possible to back up the currently active transaction log even if the database is inaccessible.

When is a sql server differential backup required?

  • A relatively small portion of the data in the database has changed since the last database backup. Differential database backups are most efficient if the same data is modified frequently.
  • You are using the Simple Recovery model, which does not permit Transaction log backups, and you want to perform backups more frequently than is practical for full database backups.
  • You are using the Full or Bulk-Logged Recovery model and want to minimize the time it takes to roll forward Transaction log backups when restoring a database.

Pages

Subscribe to RSS - Backup