February 23, 2011 at 1:18 pm
Hello to All,
I have to backup a db( 3GB in mdf file, 200GB in ldf file, no free space) to remote location.
Any suggestions?
Thanks in advance for your help
February 23, 2011 at 1:20 pm
Enable backup compression. Try to use something like robocopy to move the file, it will keep trying if a "hiccup" happens down the pipe.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 24, 2011 at 1:05 am
It seems the back compression only aviliable in enterprize edition. The best pratice is backup to local and then copy it to remote.
I saw your log file is so huge, have you tried to backup the transcation log backup? You could try to shrink the log file to make more free space. You could check the log space used information by issue: DBCC SQLPERF(logspace).
February 24, 2011 at 2:29 am
DBA328 (2/24/2011)
It seems the back compression only aviliable in enterprize edition. The best pratice is backup to local and then copy it to remote.I saw your log file is so huge, have you tried to backup the transcation log backup? You could try to shrink the log file to make more free space. You could check the log space used information by issue: DBCC SQLPERF(logspace).
I think the OP wants to backup the log for the problem he is having. but he can backup to a share \\xxxxxx\sharename\db.bak
February 24, 2011 at 6:08 am
Thanks for your replies. Probably there are some security issues. The problematic server is domain member, but my dev machine is stand-alone machine, which in this case is the only one machine with enough free space, so i took the advice of using robocopy and copied detached db to my dev machine to backup this db on my machine.
February 24, 2011 at 7:26 am
DBA328 (2/24/2011)
It seems the back compression only aviliable in enterprize edition.
Starting with SQL Server 2008 R2 Standard Edition, backup compression is available.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 27, 2011 at 8:25 pm
You mentioned that there is no free space in the log so you apparently already did a logspace on it. Try this:
BACKUP LOG TO DISK = '\\computer\share\mylog.trn'
Jim
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
February 28, 2011 at 12:04 am
gpitkis (2/23/2011)
Hello to All,I have to backup a db( 3GB in mdf file, 200GB in ldf file, no free space) to remote location.
Any suggestions?
Thanks in advance for your help
3GB in mdf file, 200GB in ldf file
Ha Its huge difference.
Why its went 200 GB ?
What is your backup strategy ?
Have you ever backup your log ?
Read the gail's article [/url]
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply