Browsing articles tagged with "databasebackup - Admins Goodies"
Oct 31, 2012
tom

MS SQL Server DB version without restoring?

Is there a way of telling which version of Microsoft SQL Server a database backup is from without restoring it? Asked by SteB RESTORE HEADERONLY FROM DISK = ‘pathTobackupFile’ The database version can be found in the column: DatabaseVersion From Jonathan Kehayias blog post here the number in this column: SQL Server 7.0 databases have version number 515 SQL Server 2000 databases have version number 539 SQL Server 2005 databases have version number 611/612 SQL […]

Continue Reading »
Jul 4, 2012
tom

How to back up a database with thousands of files

I am working with a Fedora server that runs a customized software package. The server software is quite old, and its database consists of 1,723 files. The database files are constantly changing – they continually grow and changes are not necessarily appended to the end. So right now, we currently back up every 24 hours at midnight when all users are off of the system and the database is in an internally consistent state. The […]

Continue Reading »
May 30, 2012
tom

Moving database to new server

I’m restoring a backup of a production database to a new server. The new server also hosts the application which makes use of the database. As such I’d like to use the same user/pass combination to connect to the database. The user is also included in the database backup so I thought that should work. However the user doesn’t exist as a (database) user on the new server. So I created a new server user […]

Continue Reading »
May 10, 2012
tom

If I have Postgres streaming replication on, do I still need to archive my WAL files?

I have set up two servers running Postgres 9.1, with one configured as a hot standby for the other using streaming replication. Given that, is there any reason for me to be archiving my WAL files? I’m aware that the archived WAL files allow me to “go back in time” to a previous snapshot of the database, but for my particular application, I have no need for such a feature as long as my standby […]

Continue Reading »
May 9, 2012
tom

Consistency of virtual machine backups using ghettoVCB

I have a ESXi host with both Windows and CentOS virtual machines running. A couple of them are running SQL Databases (MSSQL and MySQL). I am trying to setup a backup strategy using the ghettoVCB script, I have successfully executed the backups and ready to test the restore functions. ghettoVCB takes backups of the VM without taking them offline by creating a snapshot of the running machine and then deleting it after a successful backup. […]

Continue Reading »
Apr 13, 2012
tom

How to store 250TB of data and develop a backup/recovery plan?

I’m really new to this topic, so big apology for stupid questions. I have a school project and I want to know how to store 250TB of data with life-cycle for 18 months. It means every record is stored for 18 months and after this period of time can be deleted. There are 2 issues: store data backup data Due to amount of data I will probably need to combine data tapes and hard drives. […]

Continue Reading »
Apr 10, 2012
tom

How to schedule a backup in Plesk for Database and configuration?

I like to make a scheduled backup in plesk 10.4. My target is to Take the backup of Database and configuration and put in the FTP location. I dont see any option in backup manager in plesk. Any help is greatly appreciated. Then there is a setting “Suspend domain until backup task is completed” If I uncheck will that be a problem? Is that a way to get backup of specific database of a domain […]

Continue Reading »
Mar 16, 2012
tom

SQL Server Agent job fails to backup to remote folder

I have created a SQL Server Agent job (in SQL 2008 R2) to back up some databases on a server. This task runs fine when the backup folder is set to a folder on that machine, but when I try to set it to a remote folder location, it does not work. I get the rather unhelpful error Execution of job ‘xxx’ failed. See the history log for details. I’ve looked at the windows event […]

Continue Reading »
Mar 1, 2012
tom

Mysql large database backup

How can I backup a large database in mysql? Folder size of Database is more than 5GB & contains 1.5 Lakh tables. I have tried to backup server through phpmyadmin but no luck. Asked by user103373 At a 5GB data size, you almost surely cannot and should not use a dump (myslqdump, phpmyadmin, etc) as a backup. The reason isn’t the backup. The reason is because the restore will take a long time, potentially many […]

Continue Reading »
Feb 20, 2012
tom

Backing up SQL backups on a network share

Currently I have Maintenance Plans configured to backup SQL Server databases to local drives, then the files are picked up by Commvault nightly, and my SQL server maintenance plan deletes the backup files after they are a few weeks old. I don’t like backing up SQL server to local drives, every once in awhile commvault fails, and my hourly backups are useless–if I lose the entire server I have to go back to the last […]

Continue Reading »
Pages:1234»