SYM 400 Introduction to Database Structures.
• There are several ways of performing a backup (bak) with the SQL Server
Management Studio. one of them id to let the user specify the storage location, which
may be the main hard disk or a flash disk, or else it is important to ascertain the
accuracy of the stated path and to verify the written permission of the user. You may
, not get the backup to work until you have the necessary permissions from the abstracted
files.
Another way to endear a system of database backup can be through the SSMS graphical
user interface. To implement this method, the user can click on the + beside the word
Databases then click on the right button and choose Tasks, from the pull- down list a
choice for Backup appears. In this context in the backup window, the user will be
required to ensure that a correct path has been keyed under the Destination part. As
soon as the backup target is affirmed, the clicking of the OK button will create the
beginning of the backup. In the case the backup file has to be moved to another
folder on the same computer or to another storage medium it can be done in
Windows Explorer by using the drag and drop function or copy and paste it to the
new location. As in the previous cases, it is necessary to remember the path to the
folder where the backup was created because this data will be needed to restore the
database. In either case, we must use the correct path to the. bak file to be able to
restore the database whether using the restore command or the restore wizard in
SSMS. Backup management is an important function that protects data and allows
their restoration in the event of system failure which makes backup management an
essential function of the database administrator.
• There are several ways of performing a backup (bak) with the SQL Server
Management Studio. one of them id to let the user specify the storage location, which
may be the main hard disk or a flash disk, or else it is important to ascertain the
accuracy of the stated path and to verify the written permission of the user. You may
, not get the backup to work until you have the necessary permissions from the abstracted
files.
Another way to endear a system of database backup can be through the SSMS graphical
user interface. To implement this method, the user can click on the + beside the word
Databases then click on the right button and choose Tasks, from the pull- down list a
choice for Backup appears. In this context in the backup window, the user will be
required to ensure that a correct path has been keyed under the Destination part. As
soon as the backup target is affirmed, the clicking of the OK button will create the
beginning of the backup. In the case the backup file has to be moved to another
folder on the same computer or to another storage medium it can be done in
Windows Explorer by using the drag and drop function or copy and paste it to the
new location. As in the previous cases, it is necessary to remember the path to the
folder where the backup was created because this data will be needed to restore the
database. In either case, we must use the correct path to the. bak file to be able to
restore the database whether using the restore command or the restore wizard in
SSMS. Backup management is an important function that protects data and allows
their restoration in the event of system failure which makes backup management an
essential function of the database administrator.
