Unanswered: Recurring database snapshot using variable in filename
I'm trying to create multiple snapshots (for a school assignment) that recur every 15 minutes. I want to use a variable in the filename to differentiate. I'm getting an error that says "Incorrect syntax near '+'." Here's what I have so far:
declare @ssnum int
set @ssnum = getdate()
create database awss_ + @ssnum
(name = AdventureWorks_Data,
filename = 'c:\Snapshots\awss_data_ + @ssnum .ss'
as snapshot of AdventureWorks;