|
|
|
|
Before Using SQL Server Backup,Please do the following things at first: Back
SQL Server Connection
Add backup and restore privileges (Not Required)
Start 'Task Scheduler' service
SQL Server Connection
1.Run MS SQL Server first
2.Click the "Configuration" button on the main window
Please specify the computer than running SQL Server and account information to connect to SQL Server,Then click the "Test & Save" button.
Add backup and restore privileges (Not required)
If you use a local system account to backup or restore Microsoft SQL Server databases , this account should have the backup and restore privilege ,that is , this account should be a member of the "Backup Operators" group , or a job will fail to start.
To check an account's privilege , you can
1 . Click " Start->setting->control panel->Administrative Tools->Computer Management".
2 . Expand the "Local Users and Groups" node and select the "User" Item .
3 . Select the account name and right click on it , select "Properties" menu item.
4 . In the properties setting window , select "Member of" tab.
5 . If "Backup Operators" dose not shows on the list , click the "Add..." button to add it .
Start 'Task Scheduler' service
To schedule an automated backup or restore job , the "Task Scheduler" service should be stared . If this service is disabled , all scheduled automated jobs will fail to start.
Please following steps below to start this service.
1 .Open the service configuration window by clicking "Start->Setting->Control Panel->Administrative Tools->Services"
2 .Select the service named "Task Scheduler" . (highlight item in following picture)
3 .Change the service's startup type to "Automatic"
4 .Start this service if it's status is not "Started".
|
|
|
Home