hey there lovely people, i am trying to make an application that makes database backups, now obviously i need to add the file / filegroup backup option too , which is not a problem except for this one little problem...

How can i get the application to display a list of all the primaries and and FG's ?

I realized that this would have to be done because not all administrators use the same naming structure ...

If anyone could at least just give me an idea of where to go, thank you in advance ...

Recommended Answers

All 2 Replies

SELECT FILEGROUP_NAME(1) AS [Filegroup_Name];

This works cool and all , but i want all the stuff to display in one listbox ....

Exact procedure depends on the programming language, but idea is same. Collect your results from DB, store it in Vector/Array/List and pass it to your application GUI to display in combo box or similar

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.