We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Hello, we need to add a SnapshotUrl column to this script as this was added for SQL server 2016 and up . Msft docuumentation says it is SnapshotURL nvarchar(360),was able to use varchar(255) for my purpose. https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-filelistonly-transact-sql?view=sql-server-ver16
create table #filelist (LogicalName varchar(255), PhysicalName nvarchar(max), Type varchar(20), FileGroupName varchar(255), Size varchar(20), MaxSize varchar(20),
FileId int,CreateLSN bit, DropLSN bit, UniqueID varchar(255),ReadOnlyLSn bit, ReadWriteLSN bit, backupSizeInBytes varchar(50), SourceBlockSize int,
FileGroupid Int, LogGroupGUID varchar(255),DifferentialBaseLSN varchar(255),DifferentialBaseGUID varchar(255),isReadOnly bit, IsPresent bit,TDEThumbprint varchar(255),SnapshotUrl varchar(255) )
The text was updated successfully, but these errors were encountered:
No branches or pull requests
Hello,
we need to add a SnapshotUrl column to this script as this was added for SQL server 2016 and up .
Msft docuumentation says it is SnapshotURL nvarchar(360),was able to use varchar(255) for my purpose.
https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-filelistonly-transact-sql?view=sql-server-ver16
create table #filelist (LogicalName varchar(255), PhysicalName nvarchar(max), Type varchar(20), FileGroupName varchar(255), Size varchar(20), MaxSize varchar(20),
FileId int,CreateLSN bit, DropLSN bit, UniqueID varchar(255),ReadOnlyLSn bit, ReadWriteLSN bit, backupSizeInBytes varchar(50), SourceBlockSize int,
FileGroupid Int, LogGroupGUID varchar(255),DifferentialBaseLSN varchar(255),DifferentialBaseGUID varchar(255),isReadOnly bit, IsPresent bit,TDEThumbprint varchar(255),SnapshotUrl varchar(255) )
The text was updated successfully, but these errors were encountered: