<div>
<div class="content wysiwyg-content">
I have a developement SQL server that I would like to restore &nbsp;copies from two Live database &nbsp;on a weekly basis. I need to be able to trust a less technical person to do this on occasion so wanted to script it. However the backup file passed from the production server has a name - 
&quot;database_backup_2012_02_07_4905093&quot; etc. 
in other words they are (usefully) data and time stamped &amp;&nbsp;serial numbered. 
Is there a way within the T-SQL script to allow for this? 
------------------------------------------ 
RESTORE DATABASE [Membership] FILE = N'Membership' FROM &nbsp;DISK = N'E:\Membership_backup_2012_02_07_010001_4905093.bak' WITH &nbsp;FILE = 1, &nbsp;MOVE N'Membership' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Membership.mdf', &nbsp;MOVE N'Membership_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Membership.ldf', &nbsp;NOUNLOAD, &nbsp;STATS = 10 
GO 
------------------------------------------------------------- 
 
Thanks 
 
Nigel
</div>
</div>

I have a developement SQL server that I would like to restore  copies from two Live database  on a weekly basis. I need to be able to trust a less technical person to do this on occasion so wanted to script it. However the backup file passed from the production server has a name -
"database_backup_2012_02_07_4905093" etc.
in other words they are (usefully) data and time stamped & serial numbered. 
Is there a way within the T-SQL script to allow for this?
------------------------------------------
RESTORE DATABASE [Membership] FILE = N'Membership' FROM  DISK = N'E:\Membership_backup_2012_02_07_010001_4905093.bak' WITH  FILE = 1,  MOVE N'Membership' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Membership.mdf',  MOVE N'Membership_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Membership.ldf',  NOUNLOAD,  STATS = 10
GO
-------------------------------------------------------------

Thanks

Nigel

MSSQL Restore

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.