Re: restore a bakup database on MSDE

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks

"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> schrieb im Newsbeitrag
news:#bq4c3s0FHA.1132@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> You have 2 options:-
>
> 1. OSQL :- MSDE comes with command line utility OSQL. Using this you can
> login to SQL Server and execute any TSQL command. For
> Restore you can use RESTORE DATABASE command from OSQL.
>
> 2. Webadmin:- Web based free tool from microsoft. Download from below
site:-
>
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-
ACBC-2A332CB7F959&displaylang=en
>
> Thanks
> Hari
> SQL Server MVP
>
>
> "Martin" <martinsm@xxxxxxxxxx> wrote in message
> news:ulVz$wn0FHA.164@xxxxxxxxxxxxxxxxxxxxxxx
> > Hi,
> >
> > I habe a MSDE 2000 on a server machine. I don't habe "Enterprise
Manager"
> > or
> > "SQL Analyzer".
> >
> > How can I restore a backup database?
> >
> > This machine had MS Access XP, I can write program with VB6. Is there
> > anyway
> > to execute a SQL script "RESTORE DATABASE ..."?
> >
> > Thanks for help
> > Martin
> >
> >
> >
>
>


.

Relevant Pages

  • Re: different environment fails to fill a dataset
    ... You might have lost the relationship of the Login to the user in the db. ... Andrew J. Kelly SQL MVP ... oledbadapter.fill command to fill the dataset it fails. ... Is there anything in the environment or SQL Server that could be ...
    (microsoft.public.sqlserver.clients)
  • Re: Drop User Command
    ... In SQL Server you will be having Login and Users. ... Command to drop Login ...
    (microsoft.public.sqlserver.mseq)
  • Re: Command Line & MS SQL Server
    ... it is possible in SQL server and it is quite simple as well. ... I need to create login "Test" in SQL server and create a table named ... Now you can execute the batch file from command prompt. ...
    (microsoft.public.sqlserver.setup)
  • grant the privilege of create users
    ... in sql server 2000 for create a login I use the command sp_addlogin ... how can i do for a user diferent to sa have the privilege to create ...
    (microsoft.public.windows.server.general)
  • FYI: Delete still shows the deleted record
    ... "kit" wrote: ... new SQL Server DB and I'm borrowing code from the previous SQL Server DB ... Put this in the click event of your "DELETE" command button: ... Public Sub DelCurrentRec ...
    (microsoft.public.access.forms)