Tag Info

New answers tagged

4

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'


1

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. ...


0

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.


0

By using SQL Server Import and Export Wizard or by using T-SQL script.


0

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 ...


3

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 ...


2

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