Solved

restore sql database-generate restore script from files in folder

Posted on 2013-05-17
7
1,194 Views
Last Modified: 2013-05-27
Very often I have a request to restore sql server databases from production to out test environment for a couple of out DB servers.  Every DB servers are having around 10-15 databases on it.
Format of the backups are : DB1_backup_201305151900.bak.
When I have a request  I restore this dbs from tape to one folder on the disk, and after that I have to manually restore them. It's really a hard work and I need to automate this somehow.
If it is possible to generate a restore script from the files in directory?
The problem that need to be solved also is that db file location in production are located in drive D: and E: and on test environment only on disk E:
0
Comment
Question by:dedri
  • 3
  • 2
7 Comments
 
LVL 25

Expert Comment

by:jogos
ID: 39175178
0
 

Author Comment

by:dedri
ID: 39176981
hi, anything that does not involve powershell. My SQL servers are sql server 2005 and windows 2003
0
 
LVL 69

Expert Comment

by:Qlemo
ID: 39182104
0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

Author Comment

by:dedri
ID: 39183720
Hi Qlemo, 10x for your reply.
I've already checked this article. The problem with this script is  that it is only for one database, and I am having 10-15 databases in the folder. Also it does not provide the option to move database( on my production server databases are located on the D:\- data files  and E:\ - log files), and on test servers they are all on one drive D:\
0
 
LVL 69

Accepted Solution

by:
Qlemo earned 500 total points
ID: 39183917
0
 

Author Closing Comment

by:dedri
ID: 39199383
10x
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Run Stored Procedure uisng ADO 5 23
SQL Availablity Groups List 2 8
How can I get the entire database script? 7 15
Casting is giving error in sql server 3 12
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question