Re: Save as in SQL Server(Backup - Restore)
From: Lars Grøtteland (lars_at_nospam)
Date: 09/30/04
- Next message: Dan Guzman: "Re: sql server tape backup"
- Previous message: Martin Lingl: "Re: nested stored procs"
- In reply to: Dan Guzman: "Re: Save as in SQL Server(Backup - Restore)"
- Next in thread: Dan Guzman: "Re: Save as in SQL Server(Backup - Restore)"
- Reply: Dan Guzman: "Re: Save as in SQL Server(Backup - Restore)"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 30 Sep 2004 15:18:00 +0200
WMI? What's that?
-- - Lars "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message news:%237FDQxupEHA.1576@TK2MSFTNGP12.phx.gbl... > Just be aware that undocumented functionality may change between SQL > Server versions or service packs so it's a good practice to avoid this in > production code. > > Another method to accomplish the task is with WMI. > > -- > Hope this helps. > > Dan Guzman > SQL Server MVP > > "Lars Grøtteland" <lars@nospam> wrote in message > news:%23hVB3gupEHA.3524@TK2MSFTNGP15.phx.gbl... >> xp_availablemedia 2 - That's the command I was looking for >> >> -- >> >> >> - Lars >> >> >> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote >> in message news:emrrdOupEHA.644@tk2msftngp13.phx.gbl... >>> That is no problem. I take it you already know about the RESTORE command >>> and the MOVE option to the >>> restore command. >>> >>> If you want the user to be able to browse the directory structure on the >>> server through their SQL >>> Server connection, then you have to use some undocumented commands. Run >>> a profiler trace to see how >>> EM gets the directory structure and use those commands in your own app. >>> Note that they are >>> undocumented, use at your own risk... >>> >>> -- >>> Tibor Karaszi, SQL Server MVP >>> http://www.karaszi.com/sqlserver/default.asp >>> http://www.solidqualitylearning.com/ >>> >>> >>> "Lars Grøtteland" <lars@nospam> wrote in message >>> news:Or3bY1rpEHA.592@TK2MSFTNGP11.phx.gbl... >>>> My problem is to get "Save As" in my application. >>>> Create a new database and restore one database into the created one, >>>> and use >>>> the new one in my app. >>>> >>>> >>>> >>>> -- >>>> >>>> >>>> - Lars >>>> >>>> >>>> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> >>>> wrote in >>>> message news:u8RHZlipEHA.3724@TK2MSFTNGP10.phx.gbl... >>>> >> Are there any other way around this problem then? >>>> > >>>> > Can you explain what the problem is? First it seems you wanted to >>>> > create >>>> > database files on a network >>>> > drive. You can't do that. Then you mentioned SQLNS, which has no >>>> > relationship with your original >>>> > problem... >>>> > >>>> > -- >>>> > Tibor Karaszi, SQL Server MVP >>>> > http://www.karaszi.com/sqlserver/default.asp >>>> > http://www.solidqualitylearning.com/ >>>> > >>>> > >>>> >>> >>> >> >> > >
- Next message: Dan Guzman: "Re: sql server tape backup"
- Previous message: Martin Lingl: "Re: nested stored procs"
- In reply to: Dan Guzman: "Re: Save as in SQL Server(Backup - Restore)"
- Next in thread: Dan Guzman: "Re: Save as in SQL Server(Backup - Restore)"
- Reply: Dan Guzman: "Re: Save as in SQL Server(Backup - Restore)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
