answersLogoWhite

0

It means to make an actual back up. If you are using SQL Server just right click on the database highlight Tasks then select Back Up... follow the prompts and off you go.

User Avatar

Wiki User

14y ago

What else can I help you with?

Continue Learning about Accounting

How to backup sql database?

Use program way backup and recovery. Tool repair sql database any version starting with MS SQL Server 2000, including SQL 2005.-------------You can backup SQL server database using SQL Server Management Studio (SSMS), T-SQL or PowerShell.Limitation: Backup created using higher version can't be restored in earlier version of SQL server.


What is DBA regarding database?

The DBA for a database is the Database Administrator. The DBA's roles are to manage the installation and configuration of the database software, to manage the allocation of space, to manage security, and (in concert with the developer) to manage data organization and query optimization. There are other roles, such as supporting backup and recovery, but this is just a small list.


What is a remote dba and how does it work?

Remote DBA stands for Remote Database Administration and it allows a service to monitor and maintain a database from a remote (off site) location. It also includes backup and data recovery.


Cost and Risk of database approach?

Well, honey, the cost of using a database approach can vary depending on the size and complexity of your project. As for the risk, let's face it, there's always a chance of data corruption, security breaches, or system failures, but hey, that's just the reality of working with technology. Just make sure you have a solid backup plan in place and you should be good to go.


What does Record mean in database?

Record holds data about one object with its attributes specified in table.

Related Questions

How you backup and restore database?

To backup and restore a database, as you would do for any computer file, depends on the operating system and the database used.


What manages the security of the database check backup and recovery procedures and monitors the performance of the database?

Database administration


Where can one find more information on a backup database?

Information about database backup is available at several online websites. Barracuda, Asigra, Ahsay, iThemes, R4Services and EMC are all online sources where one could obtain information about database backup.


How do you put SQL Server in hot backup mode?

Use the TSQL backup command to backup an active database.


How you can take backup of database in mysql?

It is quite easy to back up a database using dbForge Studio for MySQL. To do this, open the tool and connect to the MySQL server. In the database explorer, right-click the database you want to back up and select Backup and Restore > Database Backup. Additionally, the tool allows you to automate the backup process using Task Scheduler.


What three levels of backup may be used in database recovery management?

i. A full backup of the database, or dump of the database.This is a complete backup of the entire database. Normally performed overnight or on weekends and usually requires that no users be connected to the database. This type of backup will take the longest time and require ample storage.ii. A differential backup of the database.The differential backup will back up only the data that has changed since the last full backup and that has not been backed up before. This type of backup can be done overnight (depending on the amount of data).iii. A backup of the transaction log only.backs up all the transaction log operations that are not reflected in a previous backup copy of the database.


What creates and maintains the data dictionary manages security of the database monitors the perfomance of the database and checks backup and recovery procedures?

database user


What is a copy of the entire database that should be made on a regular basis?

backup


Is a copy of the entire database that should be made on a regular basis.?

backup


How to backup sql database?

Use program way backup and recovery. Tool repair sql database any version starting with MS SQL Server 2000, including SQL 2005.-------------You can backup SQL server database using SQL Server Management Studio (SSMS), T-SQL or PowerShell.Limitation: Backup created using higher version can't be restored in earlier version of SQL server.


What is a sentence for database?

I will enter the new values into the database.The database is corrupt.Don't forget to backup the database.Scotland Yard has a huge fingerprint database which is also connected to Interpol.


Where can one find a backup sql database?

Backup databases aren't "found" but they are created. When designing the database, consider creating a duplicate configuration, either on a separate disk drive, or on an entirely separate server, depending on how much redundancy is desired. Then set up replication between the primary and secondary (aka backup) database so the information is stored in both locations.