Restoring databases

jai

Guys,
I need to restore a database which is 400 GB plus. Usually a normal
restore from a backup file takes about 40 minutes. I have a database
Company on a server A. I need to use the backup of database company to
restore as company1 on the same box. At the end, company and company1
would reside on the same box. Is there any way to do it faster than a
normal restore???

Thanks in advance.

Regards

Jaideep

Jan 10 '07 #1

Subscribe Post Reply

1322

Erland Sommarskog

jai (db*******@gmail.com) writes:

I need to restore a database which is 400 GB plus. Usually a normal
restore from a backup file takes about 40 minutes. I have a database
Company on a server A. I need to use the backup of database company to
restore as company1 on the same box. At the end, company and company1
would reside on the same box. Is there any way to do it faster than a
normal restore???

Are you on SQL 2000? I'm afraid not. Rather it will take longer time,
since the 400 GB for the new database needs to be initialised.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jan 10 '07 #2

jai

I am on sql2005. The database in question, is on single mdf and single
ldf with full text catalogs. Can't I do a sp_attach_single_file_db with
mdf file. I tried it on a smaller database and it created a log file.

Regards

Jaideep
Erland Sommarskog wrote:

jai (db*******@gmail.com) writes:
I need to restore a database which is 400 GB plus. Usually a normal
restore from a backup file takes about 40 minutes. I have a database
Company on a server A. I need to use the backup of database company to
restore as company1 on the same box. At the end, company and company1
would reside on the same box. Is there any way to do it faster than a
normal restore???

Are you on SQL 2000? I'm afraid not. Rather it will take longer time,
since the 400 GB for the new database needs to be initialised.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jan 11 '07 #3

Erland Sommarskog

jai (db*******@gmail.com) writes:

I am on sql2005. The database in question, is on single mdf and single
ldf with full text catalogs. Can't I do a sp_attach_single_file_db with
mdf file. I tried it on a smaller database and it created a log file.

Yes, you should be able to detach the original database, copy the files
and attach the copies. But since you asked about restore, I assumed that
you had a backup already. Also, while copy and attach is likely to be
faster, it means that the original database is offline while you copy.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Jan 11 '07 #4

by: Kim | last post by:

How do I restore a single database (selectively) from a mysql dump of many databases. ie: I have a server with a few databases on it, I have run: mysqldump --all-databases > all_databases.sql ...

MySQL Database

Restoring logs to a database

by: Edwinah63 | last post by:

Hi Gurus, i am having problems with restoring a ms sql database. i have restored the database using veritas to a different location ('g:\datafiles') in no recover mode. when i view the...

Microsoft SQL Server

Restoring Master from Enterprise Edition to Standard edition

by: Tina | last post by:

Does anyone know if there are any issues with restoring Master DB onto a server running Standard Edition from a server running Enterprise Edition of SQL Server?

Microsoft SQL Server

Restoring select databases/tables from an --all-databases backup

by: Raffi | last post by:

I use the --all-databases switch to backup my entire database. Sometimes there's a need to restore individual databases or tables form the backup file. What command should I use for this? ...

MySQL Database

Restoring Numeric Databases

by: Raffi | last post by:

Hi, I'm developing a database application that uses numeric databases. At this point not using numeric databases is not an option. Doing a mysqldump works. However when trying to restore the...

PHP

Method for restoring front end from a backup

by: rdemyan via AccessMonster.com | last post by:

I'm thinking about providing a relatively easy method for users to restore the front end from a backup. The purpose is to allow for restoring if the front end becomes corrupt. Here are some...

Microsoft Access / VBA

What is the correct sequence of Restoring databases in SQL Server 7.0

by: microsoft . public . sqlserver | last post by:

I have the back up of master(master_db.bak), distribution(distribution_db.bak), model(model_db.bak, model_tlog.trn), pubs(pubs_db.bak), Northwind(Northwind_db.bak),msdb(msdb_db.bak) and...

Microsoft SQL Server

Restoring selected tables / table data

by: Troels Arvin | last post by:

Hello, Every so often, I'm asked to help people recover data from tables that were either dropped or where to much data was DELETEed. The complications related to restoring data are a problem....

DB2 Database

restoring msdb from a network tape backup

by: Mr.Kane | last post by:

I have inherited a SQLS erver 2000 instance where the client never implemented a backup startegy for the "master" and "msdb" databases. MSDB is now showing errors and my only option for a restore...

Microsoft SQL Server

Restoring database hangs SQL Server 2005

by: DMT012 | last post by:

Hello. Occasionally on my production server when I run an automated script to restore a database from a backup it hangs and the database is put in restoring mode and just stays there, requiring me...

Microsoft SQL Server

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics