restore

How can I get a SQL Server 2005 compatible backup from SQL Server 2008 database?

I have a sql server 2008 db, I want to restore its backup to a 2005 version. Is there any way for this work? Note: I can't make a script from my db and run it. ...

SQL 2005 - any way to restore/copy a diagram?

I used the Redgate packager (ran MSI) to reset all the data in my database (i.e. I deleted everything, and let it build the new database). Unfortunately, I discovered that it didn't retain my diagrams, which has a nice arrangement and several annotations. Is there any way to copy/migrate/script the diagram from one database to anothe...

restore a postgres backup file using the command line?

I'm new to postgresql, and locally, I use pgadmin3. On the remote server, however, I have no such luxury... I've already created the backup of the database and scp'd it over, but, is there a way to restore a backup from the command line? I only see things related to guis or to pg_dumps, so, if someone can tell me how to go about this,...

Is my TFS2010 backup/restore hosed?

Hi all, I recently set up a sandbox TFS to test TFS-specific features without interfering with the production TFS. I was happy I did this sooner than I thought--I hadn't been backing up the encryption key from SSRS and upon restoring the reporting databases, they remained inactive, requiring initialization that could only come from appl...

SQL 2008 Restore from device issue

Hey chaps, I have following situation: SQL Server 2008 database, in full recovery model I created a full backup, and an hour later a transaction log backup (both to separate files, so I have a .bak file, and a .trn file) Now for testing purposes, I want to restore the database using these two files. I am doing this on the same serve...

Restoring and passing data to an already running instance of a .NET application

The goal is to have an application that runs in the system tray and can either accept user input from its actual GUI (which isn't the actual issue) OR accept command line parameters (that would actually be done via a context menu in windows explorer). Now, while I'm aware that the command line parameters are not exactly possible once the...

How can I restore a SQL Server database using SMO with full text catalogues?

Hi, I want to programatically (c#) restore a database (SQL Server 2008) which was originally from my live environment. My local environment is obviously quite different, with different drive mappings. I have followed this article (http://www.mssqltips.com/tip.asp?tip=1849) which has been a great help, but I am struggling to find out h...

How to restore content in the same Activity based on the calling Intent?

Hi everyone, here's my scenario: I start an Activity A via an AppWidget. The AppWidget displays (inter alia) 3 buttons. Each of them has its own intent. They are designed to provide information to the Activity via a class called AppWidgetReceiver. In latter I create an intent like this: Intent i = new Intent(context, CreateNoteActivity...

How to change Session for only one route in asp.net mvc?

How to handle Application_BeginRequest using a custom filter in asp.net mvc? I want to restore session only for one route (~/my-url). It would be cool, if I could create a custom filter and handle that. protected void Application_BeginRequest(object sender, EventArgs e) { var context = HttpContext.Current; if (str...

Mysql Windows "mysqldump -t" restore

Yes it's Windows sorry. I'm using mysqldump with the option -T which creates a sql and a txt file per table. mysqldump -u user -ppass db -T path I use that option to be able to restore easily one table. Now I'd like to restore all the tables. mysql -u user -ppass db < path/*.sql Obvously doesn't work Also, I don't know where do ...

Difficulty restoring a differential backup in SQL Server, 2 media families are expected or no files are ready for rollforward

I have sql backups copied from server A to server B on a nightly basis. We want to move the sql server from server A to server B without much downtime, but the files are very large. I assumed that performing a differential backup and restore would solve the problem with the databases. Copy full backup from server A to copy to server ...

Can I Rollback a restore ? SQL Server

Hi, Is there anyway to rollback a restore which performed by mistake? (using a different databases' backup file) SQL Server Thanks... ...

SQL Server 2005: Partial Filegroup restore on QA database

Okay, I am pretty sure at this point that this cannot be done, but here goes: I have a production SQL Server 2005 database with two filegroups, PRIMARY and SECONDARY. PRIMARY consists of about 2 gigs of typical database data. SECONDARY consists of 15 gigs of archived data that no longer changes. I would like to create a QA database in ...

Server RAID 5 failed...all I have left is my compiled website

Yesterday, 2 of the 3 drives in my dev server's RAID 5 decided to die on me (with no warning). I've come to grips with the fact that my data is most likely lost unless I shell out some major bucks for professional data-resortoration. People, don't be an idiot like me and treat your RAID as a data backup! Luckily I published the site abo...

Does anyone has the experience of using the new p4 replicate command in their Perforce back-up /restore script ?

Hi all, we recently performed an upgrade of our whole perforce system to 2009.02 During this exercise, we noticed that the back-up /restore process that was installed here by the Perforce consultant a year ago was not completely working. Basically, the verify command has never worked (scary !). As we are obliged to revisit our Back-Up...

Windows 7 recreate my .exes

hi, i have a few programs that check if file exist, and if its old version delete him and paste the new one. However under Windows 7 Professional i can't delete the file some System process is always restoring it (same with the dll files) and as you can imagine a lot of programs are crashing because of that behaviour. So WHAT SERVICE/PRO...

DatabaseName.bak File Transfer Problem

Possible Duplicate: Download databasename.bak file I have downloaded databasename.bak file from my hosting company, when i tried to restore that DB file in SQL server 2008 it is keep on giving me following error. The media family on device 'C:\go4sharepoint_1384_8481.bak' is incorrectly formed. SQL Server cannot process this...

Restore DB - Error RESTORE HEADERONLY is terminating abnormally.

I have taken backup of SQL Server 2008 DB on server, and download them to local environment. I am trying to restore that database and it is keep on giving me following error. An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADD...

Where to store the session object in a Standalone application?

I'm having a session object that does NOT implement the java.lang.Serializable. (its a legacy application, and now I can't go and change the code) Is there any way where I can store the session object some where and later GET BACK THE SAME STATE in a STANDALONE application. One thought is to use RMI. Is there any better way of achievin...

[rails] user's account backup and restore

Hi everyone, I am currently working on a project and i would like my users to be able to backup/restore theirs accounts. I am looking for a rails plugin/gem that would easily do that, ie : current_user.backup() => backup_file current_user.restore(backup_file) => database import/replace I don't know if my questi...