New answers tagged database-backup
Yes, there is, though you got to use RESTORE command anyway. Instead of RESTORE DATABASE, use RESTORE FILELISTONLY to get a detailed view of files in the backup. The Size column tells the file size in bytes. RESTORE FILELISTONLY FROM DISK = N'v:\MyBackup.bak'
On the first "use" command after login, MySQL scans database, tables and columns name for auto completion. If you have many db, tables it could take a while. To avoid that, launch your client with the -A option (or --no-auto-rehash) mysql -uroot -p -A You could also add the disable_auto_rehash variable in your my.cnf if you want to disable it completly. ...
You have lots of different options for doing this: http://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/impexp.htm I would recommend using Oracle Datapump as this is the most powerful solution, and would represent the best opportunity for instruction on how this is done in an enterprise environment.
By using SQL Server Import and Export Wizard or by using T-SQL script.
You should make transaction log backups much more often than just nightly. One Microsoft Certified Master (Brent Ozar) recommends you take them one per minute: http://www.brentozar.com/archive/2014/02/back-transaction-logs-every-minute-yes-really/ I'm not sure I'd go that far, but once per day is not anywhere close to often enough. IIRC, there's a template ...
Depending on your database size, checkdb can take hours to finish. It is heavy on the disk subsystem as well incurring lots of I/O's. Check out Aaron's excellent article on : Minimizing the impact of DBCC CHECKDB : DOs and DON'Ts Backups are also I/O intensive operation. I would suggest to look for a maintenance window - when activity is low or minimal on ...
Write the backups to a different drive (or array, set of spindles, controller, whatever), or to the network. To back up to the network you'll need acceptable bandwidth, and run SQL Server as a domain account. Edit: With your new information, I'm guessing you have poor-performing I/O on the server. As a stopgap measure, try to get the backups to complete ...
Top 50 recent answers are included