Backup e ripristino di un database

[FrancyDotNet]

Backup

Codice: Seleziona tutto

BACKUP DATABASE [nome_database]
TO DISK = 'C:\Path\To\Backup\nome_database.bak'
WITH FORMAT,
MEDIANAME = 'SQLServerBackups',
NAME = 'Full Backup of nome_database';

Ripristino

Codice: Seleziona tutto

DECLARE @SearchValue NVARCHAR(100)
SET @SearchValue = 'valore_da_cercare'

DECLARE @SQL NVARCHAR(MAX)

SET @SQL = ''
SELECT @SQL = @SQL + 'SELECT ''' + TABLE_SCHEMA + '.' + TABLE_NAME + ''' AS TableName, ' + COLUMN_NAME + ' AS ColumnName FROM ' + TABLE_SCHEMA + '.' + TABLE_NAME + ' WHERE ' + COLUMN_NAME + ' LIKE ''%' + @SearchValue + '%'' UNION ALL '
FROM INFORMATION_SCHEMA.COLUMNS
WHERE DATA_TYPE IN ('char', 'nchar', 'varchar', 'nvarchar', 'text', 'ntext')

SET @SQL = LEFT(@SQL, LEN(@SQL) - 11)

EXEC(@SQL)