restore

Restore database backup over the network.

How do you restore a database backup using SQL Server 2005 over the network? I recall doing this before but there was something odd about the way you had to do it. ...

Speeding up mysql dumps and imports

Are there any tricks for speeding up mySQL dumps and imports? This would include my.cnf settings, using ramdisks, etc. ...

SQL Server: Column nullability inconsistency

I have a SQL Server 2005 database that could only be restored using Restore Database The_DB_Name From Disk = 'C:\etc\etc' With Continue_After_Error I am told the source database was fine. The restore reports Warning: A column nullability inconsistency was detected in the metadata of index "IDX_Comp_CompanyId" (index_id = 2) ...

How do I store the window size between sessions in Qt?

I have a QMainWindow in a Qt application. When I close it I want it to store its current restore size (the size of the window when it is not maximized). This works well when I close the window in restore mode (that is, not maximized). But if I close the window if it is maximized, then next time i start the application and restore the app...

Database Backup/Restore Process

The backup and restore process of a large database or collection of databases on sql server is very important for disaster & recovery purposes. However, I have not found a robust solution that will guarantee the whole process is as efficient as possible, 100% reliable and easily maintainable and configurable accross multiple servers. ...

MySQL InnoDB database restore

I have to restore a database that has been inadvertently DROPped in MySQL 5.0. From checking the backup files, I only seem to have .FRM files to hold the database data. Can anyone advise whether this is all I need to perform a database restore/import from the backup, or are there other files I should have to hand to complete this? ...

Is there a SQL script that I can use to determine the progress of a SQL Server backup or restore process?

When I backup or restore a database using MS SQL Server Management Studio, I get a visual indication of how far the process has progressed, and thus how much longer I still need to wait for it to finish. If I kick of the backup or restore with a script, is there a way to monitor the progress, or do I just sit back and wait for it to fini...

Sharepoint disaster recovery

What are your disaster recovery plans for Windows Sharepoint Services 3.0 ? Currently we are backuping all databases (1 content, admin, search and config) using sql backup tools, and backuping the front end server via dataprotector. To test our backups, we use another server farm, restore the content database (following the procedure o...

"Class not Registered" restoring a Sharepoint ( WSS ) 2003 backup.dat file

I need to do some work with a backup WSS .dat file and I'm having real trouble making it do anything. I've got it installed through stsadm and that appears to have gone smoothly, but the site now redirects me to an error page - just the classic "File Not Found" one, but in the URL it suggests the errortext would be "Class not Registered...

ZRM snapshot vs InnoDB hot backup for MySQL

Are there major advantages to InnoDB hot backup vs ZRM snapshots in terms of disruption to the running site, the size of compressed backup files, and speed of backup/restore on a medium-sized to largish all-InnoDB database? My understanding is that InnoDB's approach is more reliable, faster, does not cause a significant outage when runn...

Manipulating giant MySQL dump files

What's the easiest way to get the data for a single table, delete a single table or break up the whole dump file into files each containing individual tables? I usually end up doing a lot of vi regex munging, but I bet there are easier ways to do these things with awk/perl, etc. The first page of Google results brings back a bunch of non...

How to recreate an oracle 9i database from backup files (ora files)

I'm a developer so I'm a little lost in the DBA world. Our systems guys have given me a backup of an Oracle 9i database. I have installed oracle 9i on my pc and am now trying to 'import' the backup files so I have a normal database to work with. The backup folder has on SNCF[SID].ora file and around 150 [SID]-[Date]-[counter]-[soemnum...

How do I restore a single table from a SQL Server 2005 backup?

I've got a backup made using the regular SQL Server 2005 backup command. Is there a way to restore just a single table, not the whole DB? ...

Subversion - Move Repository

I have a server that hosts my Subversion code base. That server is currently a Server 2003 box, and my IT admin wants to update it to Server 2008. This means that I'm going to need to move my Subversion repository while the server gets built up and was wondering what the best practices are for moving the repository to a new server. It...

Showing the Restore Button without a Maximize button

I want to prevent the user from maximizing the Windows Form to full screen so I have disabled the Maximize button. However, I want to be able to have the user 'restore' the Form. When they click the Restore button I want it to show a different, smaller, minified, form, which will show them a maximize button which will return the use to t...

Restore an Sql Server 2005 DB backup to Sql Server 2000

Is there a way to restore an Sql Server 2005 DB to Sql Server 2000? I'm unable to attach it either. Any tools, ideas etc? ...

Is there a way to save restore points to a CD or DVD?

Restore Points in Windows has helped me quite many times when needed. I know there is no straight way to do this but is there ANY way in Windows to write those restore points to a media like CD or DVD? ...

Is it possible to restore only the schema and stored procedures from a MS SQL database backup?

I have a full MS SQL Backup file that I would like to extract the stored procedures and schema from. Is there a way to restore only the schema definitions and stored procedures without restoring the data/table rows? ...

shareware enforcement vs time machine

Problem: Customer X is (considering) porting one of his formerly "Windows only" shareware applications to Mac OS X. One of his concerns is how to enforce the 30-day trial period and make it immune to "system rollback" software like Time Machine. Question: What is the industry best practice for preventing the use of "system rollback" sof...

SQL Server, Restore a .BKP file into an MDF file but not LDF (no space for it)

I'm in an issue where I don't have enough space to accomodate my MDF and LDF files from a LiteSpeed backup we had done. I've come up with the following sproc: exec master.dbo.xp_restore_database @database = 'OSiteDB', @filename = 'L:\OSiteDB_2009_01_07_Wed_LiteSpeed_Full.BKP', @with = 'move "O1_SITEDB" to "S:\OSiteDB_Data.mdf"', @with...