Building new SQL server
had a sql server (2000 I think) built on enterprise 2003 die. Got new hardware and am beginning the guessing game. any good reference articles, step by step of how to build new and restore backups from external hd. Old server won’t even boot.

Answer Question   |  June 15, 2011  12:56 PM
Backup, SQL Server, SQL Server 2000, SQL Server 2000 SP4, SQL Server backup and restore

SQL Server 2008 restore error
error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

Answer Question   |  March 12, 2012  7:33 AM
Restore Database, SQL Server 2008, SQL Server 2008 error messages, SQL Server backup, SQL Server backup and restore

Restore SQL Server after OS loss
I have all datafiles and backups but no OS services. What steps would I take to restore the database

Answer Question   |  February 21, 2011  11:05 AM
Backup, SQL Server, SQL Server backup, SQL Server backup and restore

Full and differential backup size same in SQL Server
Hi, Sub:Full and differential backup size same. I am facing the following problem on production server,I am getting the full backup(600MB) and differential backup size(598MB).On off peak hours I have taken full backup and just after a min I have taken differential backup but the sizes of both backups are almost same.As per BOL diff [...]

Answer Question   |  December 30, 2010  1:56 PM
Backup and restore, SQL Backup, SQL Server, SQL Server backup and restore

Error Message when restoring a SQL server DB in SQL Server Express 2008 R2
This error received and cannot determine resolution: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 10240MB per database. The DB.bak file is 1.67MB

Answer Question   |  August 26, 2010  9:20 PM
.bak file, SQL Server 2008, SQL Server 2008 error messages, SQL Server backup and restore, SQL Server error messages, SQL Server Express database, SQL Server Management Studio 2008, SQL Server restore

SQL Recovery from MDF and LDF – Missing Data
Where to start … On 6/2 we lost a major system that we found relies on a database that hasn’t been backed up since 5/7. We lost 3 of 4 HDD in a RAID5 array. We sent the drives to a recovery firm and they have recovered all of the data. However, the timestamp on [...]

Answer Question   |  October 5, 2011  2:10 PM
LDF, MDF, SQL 2000, SQL Server 2000, SQL Server backup, SQL Server backup and restore

sql server 2008 backup and restore
can u get me the command to recover the database . my backup is in d:nor.bak . as i m running the command   >restore database ‘d:nor.bak’ it gives me the message as : Incorrect syntax near ‘d:nor.bak’. pls let me know how to reatore . Regards, Rino

Answer Question   |  May 19, 2010  6:46 AM
SQL Server, SQL Server 2008, Sql Server 2008 Backup, SQL Server 2008 error messages, SQL Server backup and restore

DR/HA questions with SQL Server design
Greetings! I need your advice for two questions. This is related to design. I have a production site. It requires HA. At the same time we have a DR site. The DR site needs to have the same copy of the database for my application to run. Question 1: Is it advisable to have mirroring [...]

Answer Question   |  March 31, 2010  10:16 PM
SQL Server, SQL Server availability, SQL Server backup and restore

Reducing SQL Server backup and restore time
Our database is big (about 320 GB) and it takes some time to backup and restore. The client wants us to suggest techniques that would reduce the time. I have tried “piecemeal” restoring, which allows you to backup and restore individual filegroups in the database. It works fine with all the filegroups — except for the [...]

Answer Question   |  October 27, 2009  4:39 PM
Backup and restore, SQL Server backup and restore, SQL Server performance tuning

Techniques for storing SQL Server data online and for backing up the server
For a banking application, I would like to keep 10 years worth of data using SQL Server. I would like to keep two years online and backup the other eight years. What are some techniques to do this?  

Answer Question   |  October 27, 2009  3:50 PM
Backup, Online Backup, SQL Server backup, SQL Server backup and restore

Recovering lost SQL Server 2000 data
I lost a LDF file for SQL server 2000 — but I have the MDF. How can I recover my data?

Answer Question   |  December 13, 2010  6:47 PM
Data Recovery, LDF, MDF, SQL Server 2000, SQL Server backup and restore

sql server 2000 how can i make backup 4 file only and restore
how can i make backup 4 file only and restore

Answer Question   |  July 28, 2009  2:08 PM
SQL Server 2000, SQL Server backup, SQL Server backup and restore

Mirroring from a production environment to a DR environment
I have a production environment and a disaster recovery environment and each of them have two SQL 2005 servers in a cluster. We have two LANs — the first one is our standard/everything LAN and the second is a Service LAN. We are looking to mirror from our production environment to our DR environment. Is [...]

Answer Question   |  July 9, 2009  3:03 PM
Disaster Recovery, Production environments, SQL Server 2005, SQL Server 2005 mirroring, SQL Server backup and restore, SQL Server Mirroring

Software to automate backups for SQL Server 2008 databases
I am running SQL Server 2008 and I know how to create backups of this data manually using SQL managment studio but we are looking for a way to automate the process. Does anyone know of a product that can be utilized to do this? Or a way the managment studio can be set up [...]

Answer Question   |  June 29, 2009  4:44 PM
Automated backup, Backup & recovery, Backup software, SQL managment Studio, SQL Server 2008, SQL Server backup, SQL Server backup and restore, SQL Server Management Studio

Backup Performance Compare
How or what can I use to compare the performance of the backup performed when the database is configured to use the simple recovery model versus the full recovery model.

Answer Question   |  April 7, 2009  4:26 PM
SQL Server 2005, SQL Server backup and restore, SQL Server database, SQL Server performance

Backing up virtual SQL servers
The following question was recently submitted by a user via e-mail: I’m using ArcServe to back up our virtual machines, and I’m wondering what other tools people are using to back up their virtual SQL servers?

Answer Question   |  March 23, 2009  3:14 PM
ArcServe, SQL Server backup, SQL Server backup and restore, Virtual SQL Servers

Taking a backup of a running site on a SQL Server
How can you take a backup of a running site on a SQL Server?

Answer Question   |  February 25, 2009  8:37 PM
SQL Server backup, SQL Server backup and restore

SQL Server 2005 SP2 backup failing
This is my first post and thanks in advance for any replies. I have a backup that failed midway (about 120G of 230G) into the backup twice in the last 2 weeks. Each time, the first error that gets reported in the Application log has been, “BackupMedium::ReportIoError: write failure on backup device ‘\server_namedb_dump.bak’. Operating system [...]

Answer Question   |  February 23, 2009  7:54 PM
SQL Server 2005, SQL Server 2005 SP2, SQL Server backup, SQL Server backup and restore, SQL Server database

Error message when restoring a SQL Server database
This error received when restoring a SQL Server database: System.data.Sqlclient.Sqlerror:Create Database or Alter Database failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database.

Answer Question   |  August 4, 2011  7:16 PM
SQL Server backup and restore, SQL Server database, SQL Server error messages, SQL Server restore

Trouble backing up our SQL Server transaction logs
Our SQL Server transaction logs have not been backing up, and I discovered it’s because a database was not selected in the maintenance plan. When I select the database and save it, however, it is not saving. It keeps reverting back to the previous option. Does anyone know why?

Answer Question   |  February 10, 2009  7:13 PM
SQL Server backup, SQL Server backup and restore, SQL Server transaction logs