Tweeted twitter.com/StackDBAs/status/721628830763479041
2 edited tags; incorporated comment
source | link

how do I get Get a listing of snapshot datafilesdata files

I need to programmatically drop a database with all of its snapshots and then recreate the database and create a new snapshot. I'm having trouble locating where the snapshot files are located from within a query. Essentially

Essentially we have several environments and they are not consistent on where they place these files so I need my code to be smart enough to put these files back where they were.

Just to clarify: When I say the snapshot files I mean the .ss files.

how do I get a listing of snapshot datafiles

I need to programmatically drop a database with all of its snapshots and then recreate the database and create a new snapshot. I'm having trouble locating where the snapshot files are located from within query. Essentially we have several environments and they are not consistent on where they place these files so I need my code to be smart enough to put these files back where they were.

Get a listing of snapshot data files

I need to programmatically drop a database with all of its snapshots and then recreate the database and create a new snapshot. I'm having trouble locating where the snapshot files are located from within a query.

Essentially we have several environments and they are not consistent on where they place these files so I need my code to be smart enough to put these files back where they were.

Just to clarify: When I say the snapshot files I mean the .ss files.

1
source | link

how do I get a listing of snapshot datafiles

I need to programmatically drop a database with all of its snapshots and then recreate the database and create a new snapshot. I'm having trouble locating where the snapshot files are located from within query. Essentially we have several environments and they are not consistent on where they place these files so I need my code to be smart enough to put these files back where they were.