SQL Server Performance Forum – Threads Archive

Large Database how to divide

I am having a large database backup of 48 GB .I want to restore the database .
How should I do ?
1.take a 80 GB hard disk and take ot on it.
2.Can i share the data on multiple systems in network Please tell me the positive and negative point in support of ur answer
Also tell me how to do
Thanks

You can restore the database on this 80Gb disk without any issues using RESTORE statement. Could you please explain a bit further on sharing data on multiple systems? (in future kindly post the thread in relevant forums, edit the thread to move it to General DBA section) Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

1) You have 80GB free?
1.1) Backup database is 48Gb, but when you backup that database what was the size?, because SQL backup only ocuppate data, no space reserved space to grow. But in restore process SQL need not only 48GB, SQL need 48Gby plus space reserved to grow.
2) You want to split one database in more than one server?
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

I have taken a 80 GB hard diak and have restore the data .After restoring the data size is 48 GB. There are 2 drives in the system each of 40 Gb ,So I have kept the Primary file in C Drive and Secondary and Log file in D drive.
** Can it be possible to spilt the data base on a network.Like wise to keep Primary file on the main server and secondary on other server.if Yes how can we do it .
** Is there any issue if I keep the MDF file on one drive and Log file on other drive? Satya, can u pls tell me how to move this to the relevant section Thanks

The option you performed to seperate data file and log file is absolutely fine and it will have advantage on performance. Ok, in this case if you;re using SQL enterprise edition then take advantage of Log shipping process which will work as warm standby and you can use secondary server for read-only/reporting purposes. http://www.sql-server-performance.com/sql_server_log_shipping.asp
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx
… articles on log shipping for your reference.
(to move the thread, on your first post click on [Edit reply](Pen on notepad) icon and select the General DBA section to move the thread).
http://www.sql-server-performance.com/forum/faq.asp – FAQ page to move/edit a post. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>