Viewing 3 posts - 1 through 3 (of 3 total)
In addition to what Calvo said, you won't be able to restore it if you are on simple recovery mode. So, why backing it up if you are not going...
November 4, 2011 at 9:28 am
#1403328
Additionally, instead of using subqueries, try to rewrite the sentence using CTE.
February 16, 2009 at 12:37 pm
#944784
select * from sysfiles
February 16, 2009 at 12:34 pm
#944779