New answers tagged database-backup
This will be tough to do with the built-in schedule UI, unless you want to create 12 different schedules, but you can easily build this into your job step. Assuming it runs every night: IF DAY(GETDATE()) <= 8 OR DAY(GETDATE()) >= 28 BEGIN -- do backups END On other days (9th -> 27th), the job will still run, but everything inside the IF ...
If the full backup just grows by a few MB but your DIFF is 200MB then you're probably doing a lot of UPDATES which change the page, thus forcing the page to get copied to disk. However, full backup size won't change much as it copies all the pages anyways. This is ignoring the transaction log which in the comments you've already specified has very little ...
in order to release the space you first need to change the recovery model from full to simple, then you can release the space as you have mentioned.After it is finished you can revert from simple to full anyway this is a temporary fix.. the log will eventually grow again sooner or later..
This Oracle document describes how to do a Windows->Linux migration. You'll need to follow the same approach, but swap the source and target architectures. Obviously you'll have to create the Oracle DB service on Windows too.
You can read the files with a hex editor, but you can't restore Oracle data files backed up from a Linux server to a Windows server. The endian is different. Depending on how your database is setup you can use data pump with transportable table spaces to migrate an Oracle database from Linux to Windows. Transporting Tablespaces Between Databases
RMAN can be used for cross-platform tasks but you cannot restore your classic full backup from Linux to Windows
Yes that is correct. It will backup your database to c:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Backup\TestBackup.bak. INIT will overwrite the file everytime it backups up. Are you sure you just want one FULL backup ? What about transaction log backups? What if that backup gets corrupted (since you have only one backup and that is ...
Yes, see the Microsoft whitepaper A Technical Case Study: Fast and Reliable Backup and Restore of Multi-Terabyte Database Over the Network (DOC). On page 15, they explain how to separate out the backup targets onto multiple subnets and volumes.
You should use Ola's backup solution. Brad talks about it in more details on simple talk. The solution is very simple to implement and its tested by many organizations. Value Description FULL Full backup DIFF Differential backup LOG Transaction log backup
Top 50 recent answers are included