Database Reference
In-Depth Information
BULK INSERT [dbo].[BusinessEntity] FROM 'D:\SampleDbz\
AdventureWorks2008R2-Samples\AdventureWorks 2008R2 OLTP\
BusinessEntity.csv'
WITH (
CHECK_CONSTRAINTS,
CODEPAGE='ACP',
DATAFILETYPE='widechar',
FIELDTERMINATOR='+|',
ROWTERMINATOR='&|\n',
KEEPIDENTITY,
TABLOCK
);
3.
As best practice, perform a full database backup:
BACKUP DATABASE [PieceMealDB] TO DISK = N'C:\Program Files\
Microsoft SQL Server\MSSQL10_50.SQL2K8R2U\MSSQL\Backup\
PieceMealFullDatabaseBackup.bak' WITH NOFORMAT, INIT, NAME =
N'PieceMealDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,
STATS = 10, CHECKSUM
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where
database_name=N'PieceMealDB' and backup_set_id=(select max(backup_
set_id) from msdb..backupset where database_name=N'PieceMealDB' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup
information for database ''PieceMealDB'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'C:\Program Files\
Microsoft SQL Server\MSSQL10_50.SQL2K8R2U\MSSQL\Backup\
PieceMealFullDatabaseBackup.bak' WITH FILE = @backupSetId,
NOUNLOAD, NOREWIND
GO
4.
Back up the PieceMealDB filegroup database as follows:
BACKUP DATABASE [PieceMealDB] FILEGROUP = N'PRIMARY', FILEGROUP
= N'Secondary', FILEGROUP = N'Tertiary' TO DISK = N'C:\Program
Files\Microsoft SQL Server\MSSQL10_50.SQL2K8R2U\MSSQL\Backup\
PieceMealDB.bak' WITH NOFORMAT, INIT, NAME = N'PieceMealDB-Full
Filegroup Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where
database_name=N'PieceMealDB' and backup_set_id=(select max(backup_
set_id) from msdb..backupset where database_name=N'PieceMealDB' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup
information for database ''PieceMealDB'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM DISK = N'C:\Program Files\Microsoft SQL
Server\MSSQL10_50.SQL2K8R2U\MSSQL\Backup\PieceMealDB.bak' WITH
FILE = @backupSetId, NOUNLOAD, NOREWIND
GO
 
Search WWH ::




Custom Search