Tagged Questions
-1
votes
1answer
55 views
How to merge data from 2 databases [duplicate]
I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
1
vote
3answers
49 views
SQL Server - restore database with zero size log file [duplicate]
SQL Server backups contain meta-data about the size of the original log (LDF) file.
So if you backup a database that has a 5GB LDF file, when you restore it, you will get an (empty) 5GB LDF file. ...
0
votes
2answers
33 views
Can I recover CDC tables from transaction logs?
Is there anyway to restore CDC tables from transaction logs? My basic understanding is that CDC reads these logs, and entries that are specially marked, are grabbed by CDC. Once this has happened ...
0
votes
1answer
80 views
Is it there anyway to restore updated records in Microsoft SQL Server 2008 R2?
We have an test database configured with our web application. Due to internal web application error the entries were get updated in the database. Is it there any way to recover the updated records?
...
2
votes
2answers
89 views
Restoring differential backup from SQL Server 2005 to SQL Server 2012
We are migrating a client to a new server. Their old server has SQL Server 2005. I have attempted to perform a differential backup however I received an error about the LSN chain being broken.
Please ...
0
votes
1answer
29 views
Recover data from accidental update
I have done an incorrect update and hence I restored the DB with a backup from the previous day. I have not taken a copy of the corrupted data before restoring the backup. Is there any possibility to ...
7
votes
3answers
131 views
How can I verify that a full database restore reflects the exact source database in SQL Server?
We are decommissioning our old SQL Server 2000 Ent. instance in favor of SQL Server 2008 R2 Ent. My planned migration path is:
Terminate client connections (2000)
Full Backup (2000)
Restore (2008 ...
2
votes
1answer
66 views
Restoring a database back to a point in time before full backup was made
A problem with one of our database tables arose at the end of last week and I wanted to restore that database to a server in order to retrieve the table. We only have the last backup, and a full set ...
4
votes
2answers
82 views
Database stuck in restoring and snapshot unavailable
I tried to restore my database from a snapshot. This usually took around a minute to complete the last couple of times. When I did it today, it didn't complete for around 30 minutes and the spid was ...
1
vote
1answer
73 views
Does the SQL Server Backup Database Command also backup views from a Database?
I have a backup job (SQL Server Agent job) which will iterate through all of our SQL Server databases in SSMS, invoke the BACKUP DATABASE command to create a .bak file on a different server. This ...
0
votes
1answer
82 views
Restoring a differential backup in SQL server 2005 [duplicate]
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
2answers
233 views
SQL Server - backup / restore schema only (not a duplicate if that's what you're thinking!)
We have a DB on over 100 servers of which we want to backup / restore the structure of just 1 at a time to a specific UAT database. They're all called the same thing but vary in terms of schema - ...
1
vote
2answers
69 views
Move named instance to another server
To be honest I'm not a DBA expert. I get asked by one of my clients in terms of moving a SQL Server development instance that is stored in the production server (source) to another server ...
2
votes
0answers
35 views
Is it possible to have a valid backupset with null position?
In database restore process I need to rely on position column exists in backupset record to restore the latest backupset.
Restore the latest backup on the database
I noticed sometimes position is ...
1
vote
3answers
202 views
Transaction log for SQL Server is too big
I have a database that has a 33 gb transaction log. It is caused by the fact that the database is in full recovery mode has been used for over 5 years prior to the first backup.
I want to truncate ...
3
votes
1answer
55 views
SP for Restoring Database and performing other tasks on it
I am creating a stored procedure for our QA dept that will do the following:
Accept specific inputs to generate a consistent name, restore a database (giving it the generated name,) set the db up for ...
0
votes
0answers
129 views
Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio
I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS database instance using the master account I created when creating the ...
4
votes
1answer
449 views
Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio
I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS instance using the master account I created when creating the database ...
2
votes
2answers
150 views
Invalid data types in restore headeronly resultset
I'm trying to write a SQL Server script to iterate through .bak files in a directory and then restore them to our server. In doing so, I've created three temp tables: #Files to keep track of the ...
5
votes
1answer
188 views
SQL Recover from .bak file with NOINIT
This will, hopefully, be a nice and quick question for someone out there. It continues from my previous question.
I have a .BAK file that I'm trying to restore. The .BAK was created with the NOINIT ...
1
vote
1answer
255 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
36 views
I have deleted a table, by exporting over the same table, and selecting the 'drop destination table before insertion'
I understand this might not be the best forum, but I could sure use some help right about now. If not, please suggest a forum where I can.
I was trying to backup a table, by using the export wizard. ...
2
votes
2answers
461 views
SQL Server 2008 R2: Restore latest backup to new database from script
We have a database for each major version of our system, for each customer, for both development and test. Like so:
WHATEVER44_CUSTOMERA_DEV
WHATEVER44_CUSTOMERA_TEST
WHATEVER44_CUSTOMERB_DEV
...
2
votes
1answer
335 views
How to restore a SQL Server database along with a standalone application?
I am new to Microsoft SQL Server. I mostly use MySQL and Firebird databases in my projects.
I have a client who needs to restore some software after his computer crashed. All that is left is a pen ...
4
votes
2answers
291 views
Restore all applicable files in a backup device in T-SQL
I'm using SQL Server (2008 R2 in this case) and I am backing up my databases into backup devices (one per database). Every Sunday the device is overwritten with a new full backup, every night a ...
2
votes
2answers
141 views
When restoring a SQL Server DB from dump files on a remote NAS share, copy before restore or restore directly?
My team is considering backing up all DBs to an Isilon NAS and we're conducting time trials to see if the restore time from the NAS is quicker than performing a copy to local storage before restoring. ...
1
vote
3answers
113 views
Restoring an entire SQL Server database instance
I have a server that we will be completely reformatting then rebuilding. Everything will be rebuilt exactly as it is now - same filenames, same directories, etc.
After SQL Server is installed, I ...
7
votes
1answer
121 views
SQL Server considerations when backing up / restoring a database that uses replication
In the event that I need to restore a database involved in replication, what considerations to I need to keep in mind?
Do I need to keep backups of both the publisher and the subscriber?
Can I ...
3
votes
1answer
153 views
sql server down bad things happens
Following Situation:
You have a Database with very high transactions, the Database is about 4100 GBs
The Recovery Modell from your Database is full
Every week you make a full backup from your ...
0
votes
1answer
483 views
How To insert records in SqlExpress Database tables through sqlscript while installing setup?
I'm creating a database and all of my tables using SQL Server Express through SQL scripts. Now, I want to insert some records in tables like States (all states names), city (all city names).
How ...
2
votes
1answer
179 views
Relocate all files to folder checkbox unavailable sql server 2012
Using SQL 2012 Enterprise edition
Following instructions here for restoring a backup:
http://msdn.microsoft.com/en-us/library/ms186390.aspx#Restrictions
I need to be able to rename the database ...
4
votes
2answers
3k views
Can I restore a SQL Server .bak files without SQL Server?
I have some large .bak files from a SQL Server 2005 dump.
Can I restore these without using SQL Server, either to PostgreSQL, MySQL, or to flat text files?
An open source solution would be most ...
2
votes
2answers
274 views
Would it be possible/wise to execute 2 parallel restores from a single backup?
Every night I create a backup (to disk) of a particular database. Subsequently that backup has to be restored to 2 different servers. These restores now happen sequentially and take about half an hour ...
-1
votes
2answers
2k views
Extract mdf & ldf files from backup file?
Is there a way to extract SQL Server files (.mdf & .ldf) from a backup file (.bak) to a physical location, without restore database?
I need a restore query or script to restore files from bak ...
3
votes
1answer
1k views
Problem restoring a database in SQL Server
I am trying to follow the instructions on the following post:
http://stackoverflow.com/questions/10299811/creating-new-database-from-a-backup-of-another-database-on-the-same-server
To summarize; I ...
3
votes
1answer
78 views
Is it imperative that I backup my index files?
I have a few different instances (SQL 2000, 2005) with indexes placed in a separate filegroup. Do i need to ensure that this group is backed up, or will it be rebuilt by a restore of of the database?
8
votes
2answers
1k views
Restore database excluding FILESTREAM data
Context
We are developing a system with a large-ish database in the bottom. It is an MS SQL database running on SQL Server 2008 R2. The total size of the database is about 12 GB.
Out of these, ...
5
votes
3answers
167 views
Restoring SQL DB from down SQL Server (on domain) to existing SQL server (not on domain)
If and when my SQL server goes down and takes too long to get back up, can I restore my DB on another SQL server and run my software from there (I can point which SQL server to run from)?
Will all ...
4
votes
2answers
153 views
What is the easiest way to use a SQL Server backup to retrieve just a few rows?
I need to manually retrieve a few rows from a SQL Server 2008 database backup. Normally I create a new database, restore the database backup to the new database, and run my queries. The database is ...
6
votes
3answers
533 views
Restoring a database is not working
I have a database called FDB. I have created this database on my PC with SQL Server Express Edition and added one table. I made a backup of this database. The SQL Server version on the server is 2005.
...
2
votes
2answers
179 views
Can I move a system database from one version of SQL server to another?
We are moving our databases from one computer running SQL Server 2005 to a different machine running SQL Server 2008.
I am following the steps found here, in an attempt to copy over the master ...
5
votes
1answer
4k views
Repairing corrupt SQL Server database backup?
I'm looking at a problem for someone who was backing up to a cloud-based service. Apparently the customer's server crashed while it was performing some maintenance on the cloud-based service's ...
-5
votes
1answer
650 views
SQL Server 2000 to 2008 R2
When I try to restore a database abackup from a SQL Server 2000 to 2008 R2m, I get this error:
Actually, I don't quite get it. What does the error actually mean?
And how can I solve it?
1
vote
1answer
245 views
Same restore file (.bak), huge difference of execution duration time on various computers
First of all, the question is nothing to do with SQL performance optimization.
I have a .BAK SQL Server backup, and have restored it on my computer.
My computer: i7 2600 3.4GHz, 240GB SSD, 8GB RAM, ...
1
vote
2answers
279 views
Restoring SQL Server database backup file for read-only access - is it possible to skip the ldf file creation?
I need to read some data from a database given by its backup file. So, I issue the RESTORE DATABASE command, which creates two files - the database MDF file and the log LDF file.
Is it possible to ...
1
vote
3answers
658 views
SQL Server 2005 Restore from Full and Differential Backup
I'm not a DBA, however I have been a developer for 10yrs and am competent.
I wish to move our corporate application to a hosted service and I need to copy the data. The data centre is too far from ...
1
vote
2answers
106 views
Rename database object during restore
Is there a way to rename database objects such as tables, stored-procedures, etc, during a restore of a .BAK file to a new database?
7
votes
1answer
4k views
How can I recover data from the LDF file?
We are using SQL 2005 Express Edition. We want to read the data from the LDF file in order to restore some deleted records.
We tried using a trial version of ApexSQL which helped us a lot. Instead of ...
-1
votes
1answer
224 views
Does SQL Server full restore set the differential base?
Differential backups are taken as the difference between the current state, and the last full backup called the "differential base".
Does restoring a full backup reset the differential base? If so, ...
2
votes
2answers
484 views
What is a good way to verify that a restore completed successfully in SQL Server?
Right now, we test our SQL backups once a month by pulling the most recent backup file and restoring it onto a test database. If SQL Server says the restore is successful, we spot-check a few tables ...
