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
Jaideepjai (dbasybase@.gmail.com) writes:
Quote:
Originally Posted by
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, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||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:
Quote:
Originally Posted by
jai (dbasybase@.gmail.com) writes:
Quote:
Originally Posted by
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, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||jai (dbasybase@.gmail.com) writes:
Quote:
Originally Posted by
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, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
No comments:
Post a Comment