Re: Backup SQL Server

1: Seems this article is for you: http://www.sqldbatips.com/showarticle.asp?ID=27

2: Using the RESTORE command.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/


"Jos Roijakkers" <j.roijakkers@xxxxxxxxxx> wrote in message
news:5d4a1f3d9dd28c840efa3e7622a@xxxxxxxxxxxxxxxxxxxxx
I use MS SQL Server Express 2005 (the 'unpaid' version). I managed to create a backup of my
database using an option onder 'Server Objects'. My questions:

1. Is it possible to schedule this backup or is this only a feature of the full version of MS SQL
Server?

2. How can I restore a database from a backup?

Any help is appreciated.




.

Relevant Pages

  • Re: SP accessing other db
    ... regarding the cross-database chaining server option. ... Now the database name is hard-coded. ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Transition from Stand-ALone SQL Server to Cluster
    ... there is only one database server and it ... should be capable of handling just the database loads you put on it. ... Columnist, SQL Server Professional ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Save as in SQL Server(Backup - Restore)
    ... I take it you already know about the RESTORE command ... > "Lars Grøtteland" wrote in message ... >> Create a new database and restore one database into the created one, ... >>> Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • 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: moving sql data
    ... After setting up the database you can change the server name using the ... SQL Server MVP ... > passwords, maint.plan...) ...
    (microsoft.public.sqlserver.setup)