Is it possible to restore a MySQL database from the physical database files. I have a directory that has the following file types: client.frm client.MYD client.MYI but for about 20 more tables. I usually use mysqldump or a similar tool to get everything in 1 SQL file so what is the way to deal with these types of files? ...
Folks, Assume you receive a disconnected backup of a SQL Server database (2005 or 2008) and you restore that to your SQL Server instance. Is there a way, is there a system catalog or something, to find out when the last write operation occured on that particular database? I'd like to be able to find out what day a particular database ...
I deleted a file from a repo and now want to put it back. The best I can figure out is to: update to the revision before the delete copy the files elsewhere update to head copy the files back add them commit That just smells bad and it looses all history to boot. There has got to be a better way to do this. I have already looked in T...
Hi, I'm having serious issues with backing up and restoring a shared services provider. Using the Central Administration backup I run the backup to s:\ This completes fine. I then from another SharePoint Server choose to restore a backup and point it to the UNC path \machineipaddress\s$\spbr00DF I have given everyone full access to ...
A) What is the best solution for regularly backing up large PostgreSQL database (version 8.3 running on latest Ubuntu server); please don't say pg_dump with those painfully slow insert statements B) What is the best solution for PostgreSQL database replication that works in real world ...
i backed up a data: BACKUP DATABASE MyDatabase TO DISK = 'MyDatabase.bak' WITH INIT --overwrite existing And then tried to restore it: RESTORE DATABASE MyDatabase FROM DISK = 'MyDatabase.bak' WITH REPLACE --force restore over specified database And now the database is stuck in the restoring state. Some people have theorized ...
Hi, I've used the central admin backup facility to backup our Shared Services Provider. The backup location was a drive on a new server. I then try to restore the SSP via central admin on the new server. It fails with an error relating to the fact that it cant find the .mdf files that it requires. It is looking in the location that the...
What is the fastest path to restore a git repository after a file system error on the main server? Imagine the central server of your OSS project fails and all commits for two days are lost after restore. How do you get those back? Is it enough just to call "git push" on all clients? Or is there something else I must take into account? ...
Hi! The situation at the moment is that we have a sharepoint server which started out as a pilot but now actually runs as the production environment. The server on which sharepoint runs is an old machine which does not conforms the standard requirements so I want to move the current environment to the shiny new server. I've red a lot a...
Hello everyone, I have one database which contains the most recent data, and I want to replicate the database content into some other servers. Dues to non-technical reasons, I can not directly use replicate function or sync function to sync to other SQL Server instances. Now, I have two solutions, and I want to learn the pros and cons ...
I read some Books Online about recovery/backup, one stupid question, if I use full database backup/full recovery model, for backup operation itself, will it generate any additional transaction log to source database server? Will full recovery operation generate additional transaction log to destination database? ...
Hi, is it possible to restore individual tables from a full backup file of Microsoft SQL Server 7 (yes, I know this is really old, but our client can't upgrade for various reasons). The total backup file is about 180GB in size and restoring the whole database once a week to a development server is not pratical, as it takes several days...
Hey guys, I'm a newbie for C#. can you tell me how to backup and restore db from postgresql using C#. i'm using npgsql as data provider. Thanks ...
My computer has recently crashed and I can only run it in Safe Mode. I need to back up a SQL server 2005 database and transfer it a computer that works. Is there anyway to run SQL server 2005 in Windows Vista Safe Mode? ...
We got a nightly backup/restore managed by another source. And we need to execute an SSIS package right after restore. At the moment, all the processes are executed in a timely fashion by estimating how long every step can take which is very error prone. Question is, how can i check if restore finished and execute the SSIS package? ...
Hi there, Can anyone let me know what is the best practice for doing sql server backups i.e. FULL, differential and partial differential I will doing this from code using SMO (c#) but anyway... is it best to do a FULL backup every 1 month and a differential every day?? Just looking for a bit of guidance really Any ideas? ...
I need to convert a MySql Database to SQL server. I received the database in a zip file containing only *.frm, *.MYI and *.MYD. Im not familiar with MySQL. I downloaded and installed version 5.1 server and tools. I copied that folder containing the files to the folder where the other databases are located. Using MySql administrator, in C...
I need to do a full backup of a SharePoint app running on our production server to a our test server running SharePoint. I tried using Central Admin to back up from the prod server, zipping up the backup and then restore to the test server, but this doesnt work. Whats the easiest way to do this? ...
Hi, I am using Command line to backup and restore MYSQL Database. Let use I m having a Database Data1 having Views and Procedures in it. When in Cmd line, I use mysql dump i.e ..>bin> mysqldump -u root -proot Data1> Datafile.mysql When I use above Cmd, It creates a Backup file on bin Folder of Mysql with Dtafile.mysql Name. but the ...
When I restore SQL database by using Microsoft SQL Server Management Studio, it fails and give me this message: TITLE: Microsoft SQL Server Management Studio Restore failed for Server 'app1'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.139...