Urgent help needed - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Urgent help needed

Author

Topic

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-05 : 12:01:24

I am restoring 1.2 TB on different server. Can you recommend me the best way to apply that.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 12:08:26

RESTORE DATABASE...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-05 : 12:23:19

quote:
Originally posted by tkizer

RESTORE DATABASE...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

I have already backed up the database.

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2007-11-05 : 12:28:33

So now restore it...

Kristen
Test

22859 Posts

Posted - 2007-11-05 : 12:33:55

Is this the same question as you asked before?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=91953

I note that the Subjects are the same </sigh>

Kristen

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-05 : 12:36:25

quote:
Originally posted by Kristen

Is this the same question as you asked before?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=91953

I note that the Subjects are the same </sigh>

Kristen

Yes, But how many files do i have to create and we have only 3 drives . So how should we seperate the data and log files . Can you recommend the size of each files.

Thanks Expert(SQL server)

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2007-11-05 : 12:37:52

If it's taking so long between servers because of the size, then try zipping it up. I've used PK zip before. Then copy it to the new server and then unzip it and restore it. When you zip or compress it you should bet about 90% compression meaning you'll be left with a file around 120mb.

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2007-11-05 : 12:39:45

You keep adding to your original question. The first question was how to restore a database. Now you are asking how to split up the files. What are you trying to do exactly? Post the whole question. We can't read your mind to know what you are trying to do.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 12:40:47

quote:
Originally posted by Van

When you zip or compress it you should bet about 90% compression meaning you'll be left with a file around 120mb.

I'm pretty sure that you mean 1.2GB instead of 120MB. There's no way that a 1.2TB file is compressing down to 120MB.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2007-11-05 : 12:41:44

Yea, 120GB actually...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 12:41:59

quote:
Originally posted by sodeep

Yes, But how many files do i have to create and we have only 3 drives . So how should we seperate the data and log files . Can you recommend the size of each files.

We can't make any recommendations based upon the very little information you have posted.

Perhaps you should hire a consultant to help you with your urgent problems.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2007-11-05 : 14:03:22

Sorry for the confusion. 1.2 TB database is copied to the local drive in different server. So my question is:
1) when restoring ,should i restore directly the database .
2) or should i create the database and configure exactly the size of the files and location before i restore.And what about adding more files to the unrestored database to increase performance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-05 : 14:07:38

Configuring the database before the restore is pointless as the restore will overwrite your changes.

We don't have enough information about your environment to suggest any recommendations as to adding more files or what not.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-05 : 21:53:46

Sql will add db files based on source db during restoration.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources