Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
SELECT OBJECT_NAME (sc.[id]) tablename , COUNT (1) nr_columns , SUM (sc.length) maxrowlength FROM syscolumns sc join sysobjects so on sc.[id] = so.[id] WHERE so.xtype = 'U' GROUP BY OBJECT_NAME (sc.[id]) ORDER BY SUM (sc.length) desc
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!