Tagged Questions

-4
votes
1answer
44 views

Oracle database and data has been corrupted. Is there a way to get it back? [closed]

The Oracle database has been corrupted and both the data and backups were lost in the corruption. Is there anything I can do to recover my data? It would be terrible if it were all lost.
2
votes
2answers
1k views

media family on device is incorrectly formed. SQL Server cannot process this media family

I am trying to restore a .BAK in SQL server but get the following error: Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot ...
0
votes
1answer
101 views

Restoring a differential backup in SQL server 2005

I have created a full back up of my database by executing the line below in my application: Dim Query As String = "backup database Ari to disk='G:\Documents and Settings\i\Desktop\BKAR\" & ...
1
vote
1answer
305 views

SQL Server: Simple database restore with overwrite

What I'm trying to do is backup one of our production databases and restore them as our dev database (overwriting what's been there). That's how I back up: backup database [authfx] to disk = ...
1
vote
1answer
1k views

Full and differential restore with two backup files - SQL Server 2008

We are trying to establish a maintenance plan with 2 separate backups. One full backup over the weekend and differential backups through the week. [the differential backup has a "_diff" appended to ...
1
vote
2answers
490 views

Move (Restore) SQL Server 2005 database which does not exist before

I did not ready about this but found out after trying to restore a database from remote server and it wont restore if the database did not exist before. What I would do is create a .bak file ...
3
votes
1answer
245 views

How can I restore SQL Server database to a custom location, if the backup file was renamed?

Suppose I have an SQL Server database called bubu and the respective backup file is bubu.bak. If I want to restore it with the backing store in a custom location, I use the following T-SQL statement: ...
3
votes
3answers
414 views

How and what do you backup for a simple Oracle DB?

Background: I am in the following situation: We have a JIRA instance running on a dedicated server machine (Windows Server). It uses Oracle XE to store all the data. The JIRA instance and a Oracle ...
5
votes
4answers
10k views

Restoring a backup to an older version of SQL Server

When trying to restore a backup to a SQL Server Express 2008 database I got the following error: Restore failed for Server '...\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended) ...
2
votes
4answers
2k views

SQL Server: cold backup, shutting down services?

One of our collagues told me that they are doing "cold" backups for SQL Server so that they are shutting down services and then taking a backup somehow. I think this is all wrong! Am I right? I think ...
4
votes
1answer
3k views

Restore encrypted database to another server

I'm using a product which runs on SQLServer 2008. Understandably the company supplying it don't offer SQLServer support. When I installed the product I specified a password to encrypt the database. ...
9
votes
2answers
460 views

A Non-DBA Asks: How to Painlessly Copy/Move a SQL Server instance to another Server via Backup/Restore?

We've just got a new server so I need to copy the existing SQL Server 2008 instance over from the old db box. I normally do this by copying .mdf and log files over and attaching them but I'm not able ...
5
votes
5answers
5k views

User Permissions Messed Up following a Backup -> Restore Operation

I had to move several SQL Server 2008 databases to our new db server so I backed them all up (to .bak files), copied these files over to the new box and restored them (all done using SQL Management ...
5
votes
3answers
7k views

How to restore multiple backups

I'm using ExpressMaint and Windows Scheduled Tasks to create weekly full and daily differential backups of some MS SQL Server 2008 R2 Express databases Weekly fulls expressmaint -S ...