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.
USE [Dev] --Run the Appraisal proc passing in a few required parameters Declare @ReportData varbinary(max) Exec dbo.pAppraisal @ReportData = @ReportData out, @Portfolios = '1234567', @Date = '2014-3-31', @IncludeUnsupervisedAssets = 1, @IncludeClosedPortfolios = 1 Select c.PortfolioBaseCode, c.ReportHeading1 , a.SecTypeCode, b.Symbol, b.FullName , a.MarketValue, vs.IsUnsupervised From dbo.fAppraisal(@ReportData) a join dbo.vSec b on a.SecurityID = b.SecurityID join dbo.vSecVariant vs on vs.SecurityID = a.SecurityID AND vs.IsShort = a.IsShortPosition AND vs.SecTypeCode = a.SecTypeCode join dbo.vPortBase c on a.PortfolioBaseID = c.PortfolioBaseID
|Access Crosstab Query with Multiple Values||4||32|
|insert wont work in SQL||14||20|
|When will SQL Server MIgratoin Assistant support for IBM AS/400 iSeries DB2||4||30|
|SQL Server: Unable to remove duplicate sets in Header/Detail||6||23|