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 [MyDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[spImport852Daily] @fName nvarchar(100) AS BEGIN SET NOCOUNT ON; BULK INSERT dbo.tbl852Daily FROM ''' + @fName + ''' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) END GO
|Access join syntax when converting to T-SQL query||4||33|
|How to use spatial data types in SQL Server Database project||2||21|
|MS SQL and inserting dates into tables using stored procedures||6||15|
|Stored Procedure needs owner to execute||5||15|