| Author |
Topic |
|
KrisLewis
Starting Member
7 Posts |
 Posted - 2013-04-16 : 10:40:43
|
| I am trying to backup a very large database from a client and move it to my server. How can I remove a large table, and just backup the rest of the tables all at once. I currently am backing up the whole database to a mock database. I drop the large table than backup that database again. After this I transfer the new database to my server. This takes a very long time. Is there a faster way of doing this. Thanks for any advice. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-16 : 10:58:19
|
| are both set of tables in different file groups?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-04-16 : 11:01:31
|
| And what do you mean backing up to a mock database? Are you using native SQL Server backup? Are you using with compression? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-04-16 : 11:28:54
|
| if one of the tables is read only ( for example , the large table) - you can place it in its own file group -. That way , you'll only need to backup and restore the other tables - which are sitting on a separate file groupJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-04-16 : 11:30:06
|
| btw , there are a number of methods to transfer quicker. have you checked a non-buffered copy or SAN copy (if you're on SAN)Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
KrisLewis
Starting Member
7 Posts |
Posted - 2013-04-16 : 11:32:28
|
Hello Jack,Can you explain or refer me to a website of how to properly setup a file group. And also how to only backup certain filegroups. I have tried setting this up before but had trouble doing so. I think this is the approach I am going for.quote:
Originally posted by jackv
if one of the tables is read only ( for example , the large table) - you can place it in its own file group -. That way , you'll only need to backup and restore the other tables - which are sitting on a separate file groupJack Vamvas--------------------http://www.sqlserver-dba.com
|
|
|
|
KrisLewis
Starting Member
7 Posts |
Posted - 2013-04-16 : 11:34:19
|
Hello VisakhI am currently trying to create file groups. I have been having problems setting them up. I think Jack also gave me some advice on using filegroups.quote:
Originally posted by visakh16
are both set of tables in different file groups?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs
|
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
KrisLewis
Starting Member
7 Posts |
Posted - 2013-04-16 : 11:37:00
|
Hello Russell,I am currently for example creating a new database with a similar name to the one I am backing up and calling it (backuptable)test. So when I have the backup, I drop the large table I have. But now I will be looking into how to setup a proper file group, as Jack and Visakh have mentioned to try.quote:
Originally posted by russell
And what do you mean backing up to a mock database? Are you using native SQL Server backup? Are you using with compression?
|
|
|
|
|
Moving database faster, by dropping a large table.