I have a backup file taken from a SQL Server 2000 database and I'm trying to restore it to a 2008 database. However, I'm getting this error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\M...
I make a mistake and I have done a wrong update on my main database (hospital) (blood types have been unknown for most of patients in tblPatientFile table) but I have a daily backup database (hospitalRapor) and data are true for patients before today( and it is about 400000 records) can I copy my old data from like this [hospital].[db...
Hi there, I was working on my app recently and wanted to change the brightness of the backlight. I then wanted to restore the backlight level to it's original setting on exiting the app. Here is the code: #include "GraphicsServices.h" - (void) viewWillAppear:(BOOL)animated { NSNumber* bl = (NSNumber*) CFPreferencesCopyAppValue(CFSTR(...
Hi folks, I'm trying to restore a PostgreSQL database by executing the SQL that pg_dump created, on an empty database. I'm getting this error: ERROR: syntax error at or near "\" LINE 5211: \. lines 5210 and 5211 read: COPY auth_group (id, name) FROM stdin; \. It works fine on my Linux server, where I use this command: psql -U ...
In SQL Server Management Studio, if I attempt to restore a database from a backup file with a command like: RESTORE DATABASE somedatabase FROM DISK = '<virtual disk>:\<path>\<backup file>'; I get a "file not found" error. I'm creating with the "subst" command. But if I replace with a physical disk and with the complete path, the ...
Hello. I need to sync two PostgreSQL databases (some tables from development db to production db) sometimes. So I came up with this script: [...] pg_dump -a -F tar -t table1 -t table2 -U user1 dbname1 | \ pg_restore -a -U user2 -d dbname2 [...] The problem is that this works just for newly added rows. When I edit non-PK column I get...
Hello, everyone! I have a Plone installation in my home directory under Linux. ~/Plone. This was made from a default distribution of Plone from its website. So Plone compiled own python and is bundeled with Zope. Please tell me, which files are necessary to backup if I want to: 1) Backup the whole data ever stored in my Plone instanc...
Hi there, assuming there is no backup of the original, can I restore application.master file in the _layouts directory in MOSS 2007 back to the default spec? Either that or does anyone have a copy of the default application.master file that they can share? Thanks! ...
Hi, I guess, i couldnt find solution to this problem. The partition of my hard drive containing the source codes is corrupted, however I still do have one partition intact containing the SVN repository of that source code. Can anyone suggest me if I can retrieve whole data (my commited source code) from the repository alone? Regards Var...
We have a new installation of TFS 2010 (on SQL Server 2008), and I'm planning the backup and recovery process. It seems the configuration information and data is stored in the Tfs_Configuration and Tfs_DefaultCollection databases (and additional Tfs_[CollectionName] dbs if you have more than one collection). In a test setup, I tried ba...
Hello, I'd like to detect if my application is minimized under certain situations, and if it is, the window needs to be restored. I can do that easily as follows: if(this.WindowState == FormWindowState.Minimized) { this.WindowState = FormWindowState.Normal; } However, what happens if the user first maximizes the form, then minim...
When I began, I used pg_dump with the default plain format. I was unenlightened. Research revealed to me time and file size improvements with pg_dump -Fc | gzip -9 -c > dumpfile.gz. I was enlightened. When it came time to create the database anew, # create tablespace dbname location '/SAN/dbname'; # create database dbname tablespace...
I am able to use SMO to build a treeview similar to the Locate Backup File dialog from SSMS. I can list folders on the server, and if there are backup devices, those will be listed as well. One thing I can't seem to duplicate is how to browse for a backup file to restore that was not originally backed up from the server (so it's not in...
Hello there, The application I am now trying to support (a former creation of mine) is a complete mess, and so I programmed an extension to it as a separate executable which I then launch, call application.minimize; and WaitForSingleObject (the recently created process). Right after that I call application.restore to get me back to wher...
My Git repository is on the server and I need to... restore the repository remove logs / history remove all files How could I do it? Thank you. ...
I've found the Stack Overflow question describing how to backup the IIS Metabase in C# here, and I have been successful at getting that to work using the code referenced here. However, I am having difficulty restoring those backups (or indeed any backups created manually in IIS) using C# code. Does anyone know how to do this, or even i...
My Wordpress blog appears to have been hacked and now blogs do not save and any changes I make such as approving a comment do not have effect. I am trying to backup my website so as to uninstall wordpress and perform a clean re-instillation. I want to create a backup so that when i restore the website will appear with everything the same...
I have a table in Oracle for users. I am going to install new schema and want to backup all users with passwords and other fields. I tried exp and int utilities, but imp doesn't recover anything. I created temporary user in USERS table. Then I did backup with command: exp user_owner/password file=file.dmp table=USERS rows=yes indexes=n...
Hi there, I'm working on an iPhone app that lets the user draw using GL. I used the GLPaint sample code project as a firm foundation, but now I want to add the ability for the user to load one of their previous drawings and continue working on it. I know how to get the framebuffer contents and save it as a UIImage. Is there a way for m...
My application has a tray icon which, when double-clicked, hides or shows the application window. My issue is that I can't seem to bring the window to the foreground if it was in a minimized state when it was hidden. For instance, say the user minimizes the application and then double-clicks the tray icon. The application window is then...