I need an sql script to restore .bak files from a local backup folder
$10-30 USD
Completed
Posted over 5 years ago
$10-30 USD
Paid on delivery
I created a backup of databases from an instance using [login to view URL]
As far as I can tell the backup ran smoothly. The script I sued was this:
sqlcmd -E -S .\COMPAC -d master -Q "EXECUTE [login to view URL] @Databases = 'USER_DATABASES', @Directory = N'C:\backup', @BackupType = 'FULL'" -b -o C:\Log\[login to view URL]
Now I want to restore the bak files into another machine using FirstResponderKit. In the end I want to restore using the same instance name and same version of sql Express. But for testing purposes I want to use instance sqlexpress )
I already installed the scripts FirstResponderKit. I need a script using "sp_DatabaseRestore"
Thanks for watching. Let me know if you have questions.
I have 5 years experience in Data base management.I have created many log restore logic including full,differential and log backup.I went through your requirement,I can quickly assist you on your task
$14 USD in 2 days
5.0 (3 reviews)
2.2
2.2
8 freelancers are bidding on average $24 USD for this job
Hi
I have more than ten years of experience in oracle,sql server database administration development design analysis and deployment.
I can handle all of your requirement as per project description
Please also review my profile and send me message to discuss in details
Thanks
why dont you restore it via sql server menu
its very easy to restore your backup file to sql server via straight way connecting your visual managment studio
I am a working professional with 3+ years of experience in Database concepts and Database administration.
I have worked in MSBI technologies. I have fare knowledge of Data warehouse and ETL. Also I have hands-on experience on reporting tools such as SSRS, Power BI, tableau, etc.
Glad to work with your projects.
I have 5 years experienced in both SQL DBA and SQL Developer.
I have handled sp_databaserestore procedure for one of my DATA Masking project with run time value.