Backing Up and Restoring Databases by Using the - RBAP-MABS

download report

Transcript Backing Up and Restoring Databases by Using the - RBAP-MABS

Backing Up and Restoring
Databases by Using the
SQL Server 2000
The backup and restore components of
Microsoft® SQL Serverâ„¢ 2000 allow
you to create a copy of a database. This
copy is stored in a location protected
from the potential failures of the server
running the instance of SQL Server.
You can back up and restore the
configuration database and content
databases for your server. This backup
and restore method allows you to
recover from a server failure.
Where can i find the Enterprise
Manager?
Click Start, Microsoft SQL Server
then choose Enterprise Manager.
Restoring Database
When you have completed
these steps, your restoration is
complete.
Similar to the Restoration Procedure,
the Backup procedure can be done
through the Enterprise Manager
Click Start, Microsoft SQL Server then
choose Enterprise Manager
Backing Up a Database