Accessing the file of a T-SQL BACKUP call

[Uwe Keim]

Trying to provide a backup "button" inside the C# Windows Forms application on a client PC that connects to a SQL Server database, I want to grab the resulting backup file of a call to the BACKUP DATABASE [^] T-SQL function. Since the BACKUP DATABASE function takes a file path that is relative to the SQL Server itself, I see no reliable way to get the resulting backup file from the client. My ideal way would be: 1.) Call the BACKUP DATABASE function from my client application. 2.) Specify to backup to a local file (or even better: a C#/.NET stream[^]). 3.) Capture the resulting BAK file from my client application. Question: Is this possible to achieve? (I will cross-post this message to the C# forum, since I am unsure whether this is more an ADO.NET topic) Thanks Uwe

• My personal 24/7 webcam • Zeta Test - Intuitive, competitive Test Management environment for Test Plans and Test Cases. Download now! • Zeta Producer Desktop CMS - Intuitive, very easy to use. Download now!

[scottgp]

On the link you included for the BACKUP command documentation, you'll see a section named "Backup History Tables". You can try reading those system tables - it looks like physical_name in the backupfile system table might have what you want. Scott

[Uwe Keim]

Thank you, Scott! I will try to investigate. The idea was to have the user do ZERO configuration, except specifying the connection string. Hopefully I will manage to do. Cheers Uwe

• My personal 24/7 webcam • Zeta Test - Intuitive, competitive Test Management environment for Test Plans and Test Cases. Download now! • Zeta Producer Desktop CMS - Intuitive, very easy to use. Download now!

[Vimalsoft Pty Ltd]

Good Day Uwe Someone asked a very same questions weeks ago and i have given an answer. please search anything by me here on CP.

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.somee.com vuyiswa@its.co.za http://www.itsabacus.co.za/itsabacus/

[Uwe Keim]

Thanks! If found this one [^] and several others [^]. But seem to have no match :-( Anyway, I keep searching for a match :-)

• My personal 24/7 webcam • Zeta Test - Intuitive, competitive Test Management environment for Test Plans and Test Cases. Download now! • Zeta Producer Desktop CMS - Intuitive, very easy to use. Download now!