I am using Sql Server 2008 and would like to create a user login that can only have a readonly view of the data, create backups and restore the database. The first two I can do fine, using db_datareader, db_datadenywriter and db_backupoperator. I have problems with the restore however. From what I have read, you have to make the user ...
I've got a 3.5gb database dump. Is there a way to restore just a single table from that file to a differently named table in the same database without editing the file, using mysqladmin, or some other commonly available command line application that runs on FreeBSD 6? ...
I'm almost certain about the answer, but the situation is so critical that I have to ask this question even though I'm %99 sure about the answer. Someone in our office made a backup of a MySQL database and he restored it on a wrong destination database overwriting everything on that destination (The schema of both databases were the sam...
Specifically, I want to create a backup of a list, then make some changes to that list, append all the changes to a third list, but then reset the first list with the backup before making further changes, etc, until I'm finished making changes and want to copy back all the content in the third list to the first one. Unfortunately, it see...
Let's say I have two database instances: InstanceA - Production server InstanceB - Test server My workflow is to deploy new schema changes to InstanceB first, test them, and then deploy them to InstanceA. So, at any one time, the instance schema relationship looks like this: InstanceA - Schema Version 1.5 InstanceB - Schema Vers...
I have come across some very unexpected (and incredibly frustrating) functionality while trying to restore the state of a list of CheckBoxes after a screen rotation. I figured I first would try to give a textual explanation without the code, in case someone is able to determine a solution without all the gory details. If anyone needs m...
I create backups using the same .bak file. I've made a script to automagically restore this backup. RESTORE DATABASE [xxx] FROM DISK = N'xxx.bak' WITH FILE = 10, NOUNLOAD, REPLACE, STATS = 10 GO Here, the backup set to restore is explicitly specified. However, I always want to restore the latest set available. By default, it us...
Hello, We had a ClearCase Server in an other domain. We wanted to migrate a particular VOB to new ClearCase server in an other domain. I took the back up which was take yesterday night and restored the VOB in the new server(without the vob_restore utility) I used the command to describe the restored vob cleartool> describe -lo...
I only have SQL Server 2008 (Dev Edition) on my development machine I only have SQL Server 2005 available with my hosting company (and I don't have direct connection access to this database) I'm just wondering what the best approach is for: Getting the initlal DB Structure & Data into production. And keeping any structural changes/da...
Hey everyone, I will do my best to explain in detail what I'm trying to achieve. I'm using C# with IntPtr window handles to perform a CTRL-C copy operation on an external application from my own C# application. I had to do this because there was no way of accessing the text directly using GET_TEXT. I'm then using the text content of t...
Hi, I am here to ask about a way to handle data between two databse servers. I have my one application running in my city office and another in country office. My City office has got regular[ un-interrupted ] internet connection but my country office do not have. It gets connected to internet in evening time once a day only. I have ...
We are really in a mess. The following is what happened. We have taken backup of WSS_Content database. From Central Administration Page we remove the database. Added a new database for the website. Now we are getting the below error HTTP/1.1 404 Connection: close Date: Wed, 07 Apr 2010 10:04:54 GMT Server: Microsoft-IIS/6.0 X-Power...
Hi guys... I am developing application to be run in central server and distributed computers. I am supposed to write application to backup the data from distributed machines and merge it in central server. I thought of compressing whole local database and sending it to server for merging. But as the database size grows the size of comp...
Hi everyone, I have previously exported the default preferences but accidentally deleted it. Is there anywhere I can download the default set of preferences from? I am running the latest version on Mac OS X. Thanks, Dany. ...
I see a lot about reverting back a revision, but is there a way to specify a file that you want to restore? Basically, svn up show a bunch of files have been deleted... (D filename) I want to "undelete" those... ...
I backed up my internal hard drive (C:) using SyncBack onto an external (USB) hard drive with maximum compression. I then performed a clean install of Windows Vista onto the computer. I forgot to copy the SyncBack logs before the clean install. And now when ever I try to restore a directory, the RAR/ZIP files are copied to the system...
Hello Guys, I've a problem. Duplicity is perfect for backups, I love so much that can be able to do incremental diff tars, but ... when restoring duplicity seems don't apply same concept. Basically I need to restore only changed files (obviously after a full backup) but I can't figure how do that. When I try to restore a directory I g...
I have a SQL Server 2008, which is part of a domain. Now I make a backup of a database of this server and restore it on a SQL Server, which is not part of a domain. I have an C# application, which uses this database. On the NON-Domain machine I get now exceptions like this: "Cannot execute as the database prinzipal because the principia...
Any idea why my Restore command works fine when run in Management Studio 2008 but not when run from the dos prompt? Shown below is the error when running from the dos prompt. C:\>SQLCMD -s local\SQL2008 -d master -Q "RESTORE DATABASE [Sample.Db] FROM DISK = N'C:\Sample.Db.bak' WITH FILE = 1, MOVE N'Sample.Db' TO N'C:\Program Files\M...
I am using Ubuntu 9.10 with XAMPP ( Lampp "MYSQL 5.1.45 PHPMYADMIN 3.3.1 PHP 5.3.2 ) What my problem is, is that I set up my testing env to debug my scripts locally and when I did so there arose a problem. This problem is that I used firefox's addon SQLinject ME to test for weakness' and upon doing so it caused mysql to change the defaul...