Backup Scenario

Home

Backup Scenario

Author

Message

Posted Saturday, April 28, 2012 11:06 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, May 18, 2013 5:28 AM
Points: 11, Visits: 80

Hi All

my qns is
i have 70GB space and how to take a full backup and database size is more that 120 gb

thanks all

Post #1292050

Posted Saturday, April 28, 2012 2:36 PM

Valued Member

Group: General Forum Members
Last Login: Monday, February 18, 2013 6:53 AM
Points: 60, Visits: 122

1. Arrange some more space or if you space othe drive then try to take strip backup.
2. get any backup compression tool like redget or litespeed.

Post #1292069

Posted Tuesday, May 01, 2012 6:33 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 6:59 AM
Points: 13,378, Visits: 25,163

Compression is about the only way you can put X+5 into a space for X. It's that simple.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1293096

Permissions