Viewing 7 posts - 136 through 142 (of 142 total)
Hi Rajeev,
The LiteSpeed compress your database backup file by 75-95 % which means if your database file is about 50GB in large, the compressed backup file will be only of...
December 2, 2008 at 5:08 am
Hi YaHozna,
Please let us know the SQL Server version you are using. This is required before we can go in details.
Regards
Atul
December 2, 2008 at 4:51 am
This is duplicate question. Avoid posting duplicate question.
Please refer to :
http://www.sqlservercentral.com/Forums/Topic611918-357-1.aspx
Regards
Atul
December 2, 2008 at 4:50 am
Hi Rajeev,
The best you can achive by using the third party tool. Some of them are as LiteSpeed by Quest Software and SQLBackup by Radegate.
I am not promoting any thirdparty...
December 2, 2008 at 4:30 am
Thanks for pointing out my mistake. Yes, we should truncate the log file just before the Database backup.
I agree with you on usage of Shrink option in database files. One...
December 1, 2008 at 5:05 am
1. I did mention that the command should be used once the Full Backup is taken. This eliminates the chances of any data loss.
2. Performance will hit, depends on the...
December 1, 2008 at 4:44 am
You can use the below command to shrink the data and log files.This command can be used just before you will taken the Full backup of your database.
DECLARE @Database_Name Varchar(50)
SET...
December 1, 2008 at 4:14 am
Viewing 7 posts - 136 through 142 (of 142 total)