0

Dynamically restore database in SQL server with multiple files. I have a requirement to restore database from multiple files as below.But how to write a query to get files which are available in that specific folder because no.of files today is 3 tomorrow it may raises to 4.

enter image description here

Improve this question
1
  • This answer may help for what you want. Commented Jul 13, 2020 at 6:29

1 Answer 1

Reset to default
0

There is a system defined extended stored procedure called xp_dirtree. You won't find any microsoft documentation on this - it is unsupported. It's easy, it's built in, but use it at your own risk. It could theoretically disappear when you upgrade your SQL install.

Alternatively, you can use xp_cmdshell, but the general advice to disable this extended procedure in sys.configurations, because it is inherently dangerous.

You could write your own CLR stored procedure. Jonathan Kehayias has an excellent article on this.

You could write your own application or service to manage your backups.

Or you could buy one of the several products which manage this kind of thing. A recommendation on which one is not really on topic for stackoverflow.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Yeah I knew to get filenames from that folder.My question is how to automate these restoring processing.I need script to get dynamical disk statements based on the file count.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.