Viewing 4 posts - 1 through 4 (of 4 total)
Why don't use try to back just data file up and restore it in the target server?
January 18, 2007 at 12:38 pm
There are some limitations.
Columns per base table: 1024
Rows per table: Limited by available storage
For more info, please refer to BOL with title "Maximum Capacity Specifications"
Regarding table...
August 13, 2004 at 6:10 pm
The best way from my experiences is that to include full backup plan in your logshipping schema.
For example,
From 3:00 Am to 11:00 Pm do logshipping.
at 11:10 PM do full...
August 13, 2003 at 5:19 pm
Hi, balbirsinghsodhi
After truncating log, you need to shrinkdatabase, then you can see the reduction in size.
Use DBCC SHRINKFILE('log file name')
August 13, 2003 at 5:00 pm
Viewing 4 posts - 1 through 4 (of 4 total)