Re: Save as in SQL Server(Backup - Restore)

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Lars Grøtteland (lars_at_nospam)
Date: 09/30/04 

Date: Thu, 30 Sep 2004 14:08:20 +0200

Thanks a lot from Norway. You have really helped me! 

-- 
- 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/
>> >
>> >
>>
>
>

Relevant Pages

  • Re: Save as in SQL Server(Backup - Restore)
    ... I take it you already know about the RESTORE command and the MOVE option to the ... > Create a new database and restore one database into the created one, ... >> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Restore Database
    ... we tend to ask for exact output and the command ... >>Tibor Karaszi, SQL Server MVP ... >>>>specified in the RESTORE command. ...
    (microsoft.public.sqlserver.server)
  • Re: Restore SQL database (MSDE)
    ... Read about the RESTORE command in Books Online, and especially the MOVE and REPLACE parameters. ... Tibor Karaszi, SQL Server MVP ... > get the error message "The backup set holds a database other than the ... > existing 'our dbname' database". ...
    (microsoft.public.sqlserver.server)
  • Re: Sql problem
    ... Read about the REPLACE option for the RESTORE command. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Backup SQL Server
    ... 2: Using the RESTORE command. ... Tibor Karaszi, SQL Server MVP ... How can I restore a database from a backup? ...
    (microsoft.public.sqlserver.tools)