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...

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?   Software/Hardware used: SQL Server

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?

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

how can i make backup 4 file only 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...

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 to do this? It's not...

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.

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?

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?

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...

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.

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?

Recovery models for SQL Server databases

What are acceptable recovery models for the Master and MSDB databases?

Recovering a truncated table on a SQL Server

How can I recover a truncated table on a SQL Server?

sql server 2005 mirroring

i have 2 servers, with sql server 2005 standar version, running mirroring, can i see if the data is being updated? how know that? can i make backups while running my mirroring?

Backing up and copying a database across SQL Servers

I have SQL Sever 2005 on both servers A and B, although I do not have SQL Studio Manager on server A. I would like to backup a SQL database from server B onto server A, and then copy it over to server B and restore it to the same database. How would I go about doing this?

Restoring to the end of a log backup in SQL Server bulk-logged recovery mode

In bulk-logged recovery mode in SQL Server, how can you restore to the end of a log backup that includes a bulk event? It seems to me that everything after the bulk event is useless. How could I do this?

Backing up SQL Server with specific settings

I have set up my SQL Server backup using the native backup and restore option, but I want to have the files append for 5 days and then have the original file overwritten for the next 5 days. Right now, it's set to append the entire time, and this fills the disks rather quickly. How can I achieve...

Backup/Restore a DB from Microsoft SQL Enterprise Manager to SQL Server Management Studio Express

Hi Is it possible to copy a DB from a server that has a genuin SQL Enterprise Manager to a server that has SQL Server Management Studio Express installed? Both servers are on the same net. I get following error when trying: Restore failed for Server 'PROGTST\SQLEXPRESS'. ...

How to restore a SQL Server 2000 database using a backup

Could you please educate us on how to restore a database using a backup? We have a Mambilla PR software(.net application)and SQL Server 2000 backend. We run the backup before any major change to the database.