4
votes
1answer
77 views

Restore database from backup file, where file name matches reg expression

I am doing the below : RESTORE DATABASE UAT FROM DISK = 'E:\Databases\backup\MY_LIVE_20120720_070001.bak' WITH REPLACE But I want to be able to use a file location that ignores the numbers in the ...
0
votes
2answers
415 views

Fresh SQL Server DB restore works most times, but fails sometimes

I'm working on an automated setup of a Windows Server 2008 R2 Core with IIS and SQL Express I'm starting with a fresh (just installed) OS in a VM (virtualBox in this test case) My scripts then ...
0
votes
1answer
216 views

Can a Sql Server standard edition backup be restored to web edition

If I have two instances of Sql Server 2008 R2. One is standard edition, one is web edition. If I take a backup of a database from the standard instance can I restore it to the web edition instance?
8
votes
2answers
276 views

Ways to convince management of a high cost

new here, greetings and such. My problem is relatively simple, but the situation is a tad odd. Currently, I have just been hired on to improve (essentially fix) a server room for a health care ...
1
vote
5answers
1k views

Determine LSN of database in NORECOVERY mode

I'm restoring transaction logs to a database, but need a way to know which transaction log I should start with. Typically I'll see something like this: The log in this backup set terminates at ...
1
vote
1answer
82 views

SQL Server 2008: Is it possible to store differential backups in a separate files?

We're moving some of our applications to a new hosting provider and we want to make it seamless for our users. Nonetheless, we have big databases and we've got to move about 48GB of data. Our ...
1
vote
2answers
181 views

SQL Management Studio - Restore from device problem

When specifying the Backup location by trying to click the Add button the dialog hangs and does not recover. This happens on all of our SQL 2000/2005/2008 environments. Could it be due to them running ...
0
votes
2answers
97 views

Can SQL Server (2008) transaction logs handle the database being dropped and re-created?

We're trying to restore a database (created programatically by running a hand-crafted SQL script we have). Our backup routine is to create a full backup of every database on the SQL Server 2008 ...
1
vote
1answer
137 views

Maintenance window and recovery for a large database

One of our teams is developing a database that will be somewhat large (~500GB) and grow from there (I know 500 Gigs may seem small to many of you, but it will be one of the larger databases in our ...
2
votes
1answer
346 views

Does the full backup truncate transaction log?

Does the transaction log get truncated when I take a full backup using command BACKUP DATABASE AdventureWorks TO Adventurewks GO Or do I have to take a log backup separately? BACKUP LOG ...
0
votes
1answer
97 views

Sql Server: Determining which transaction logs need to be restored

If you have (say) 10 transaction log backups and some, all or none may have been restored to the database. Is there a way to determine which files have already been restored? Thanks Dave
0
votes
3answers
202 views

How to access SQL files from a BKS file?

I have a BKS file that is around 20GB. How do I extract the MSSQL files from that? Thanks
0
votes
2answers
167 views

SQL Server Backup modes, and a huge log file

Okay, I'm not a server administrator, a network guy, or a DBA. I'm merely a programmer helping out a small company. They have IT guy who isn't MS centric (most stuff is on Mac) and he and I are ...
1
vote
1answer
158 views

What is the BRU Server Disaster Recovery Procedure?

How do I go about performing a full, bare metal disaster recovery from BRU Server backups? I have backed up the entire C:\ (including Windows, Program Files etc) of a test machine (using Open File ...
0
votes
0answers
480 views

I/O error on restore restart using Red Gate SQL backup - the default backup directory exists

I am getting the following error on log restores for a certain DB in a log shipping setup: During restore restart, an I/O error occurred on checkpoint file 'H:\DFLT\RestoreCheckpointDB22.CKP' ...
0
votes
1answer
44 views

sql server backup

Is there any way to to restore a backup created on sql server 2005, onto sql server 2000? Edit: all I have is the .bak file, no access to the original database.
2
votes
3answers
127 views

Restore SQL Server database to new server and spilt primary to file groups?

Thanks in advance for all help. We are building a new SQL Server 2008 prod box. I need to take the data from the current prod box and restore on the new one. I would like to get the databases set up ...
1
vote
3answers
747 views

Cloning SQL Database via Backup-Restore: 'Restoring…' takes a looong time

I needed an exact copy of a database under another name. I choose for cloning SQL Database via Backup-Restore, using SQL Mgt Studio 2008. Firstly, when restoring the database; I received an error. ...
4
votes
3answers
401 views

Looking for a script to restore a SQL server backup

I'm looking for a script to restore a SQL Server 2005 backup. Ideally the script will have the following features handle backup files on a network location Handle different file structure of source ...
1
vote
2answers
919 views

Restore Mdf file from a Crashed Hard Disk

I have a MS SQL server 2005 database on my database server. Recently the database server crashed, so I need to move the database to a new server. Is there anyway to restore teh mdf file from a crashed ...
1
vote
4answers
713 views

How to permanently change where MSSQL stores database information?

Using SQL Server Management console for SQL Server 2005 we go to Server Properties --> Database Settings --> change database default location from c:\blah\blah to E:\MSSQL\DATA We restart ...
2
votes
4answers
2k views

SharePoint - Do DPM and SQL backups affect each other?

I am trying to clear up an ugly maintenance plan on SharePoint databases that happen to also be backed up by Data Protection Manager (which is setup to take snapshots at 15-minute intervals). The ...
0
votes
2answers
179 views

Correct procedure for preventing a spid from rolling back

Today I had a situation where I wanted to cancel an update to a table and several indexes and immediately restore back the database from a backup. I issued a kill command to kill the updating SPID. ...