The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_add_log_file_recover_suspect_db(nvarchar @dbName, nvarchar @name
, nvarchar @filename
, nvarchar @size
, nvarchar @maxsize
, nvarchar @filegrowth)
MetaData:
-- -- Name: sp_add_log_file_recover_suspect_db -- Purpose: Adds a log file to a suspect database and runs -- recovery on the database. This SP should only be used -- on databases that have been marked suspect due to -- insufficient data (error 1105) or log (error 9002) space. -- create procedure sys.sp_add_log_file_recover_suspect_db @dbName sysname -- database name ,@name nvarchar(260) -- logical file name ,@filename nvarchar(260) -- OS file name ,@size nvarchar(20) = NULL -- initial file size ,@maxsize nvarchar(20) = NULL -- maximum file size ,@filegrowth nvarchar(20) = NULL -- growth increment as if (SERVERPROPERTY('IsMatrix') = 1) begin raiserror (28401, -1, -1, N'sys.sp_add_log_file_recover_suspect_db') return (1) end EXEC sys.sp_add_file_recover_suspect_db @dbName, 'LOG', NULL, @name, @filename, @size, @maxsize, @filegrowth
No comments:
Post a Comment