how to restore database in SQL 2005

17 Aug 2006 2:37 PM

Kamil Skup

17 Aug 2006 6:56 PM

Paul S Randal [MS]

Start by reading the Books Online entry for RESTORE DATABASE.

--
Paul Randal
Lead Program Manager, Microsoft SQL Server Storage Engine
http://blogs.msdn.com/sqlserverstorageengine/default.aspx

This posting is provided "AS IS" with no warranties, and confers no rights.

Show quote

"Kamil Skup" <ks***@wp.pl> wrote in message
news:O9$myqgwGHA.4612@TK2MSFTNGP02.phx.gbl...
> how to restore database in SQL 2005
>
>

17 Aug 2006 8:34 PM

Keith Kratochvil

The syntax has not changed for the past couple of releases. If you could
restore a database on SQL7 or SQL2k, you can restore a SQL2k5 database.

As Paul pointed out, the first place to start reading about the syntax is
Books Online.

You can access it via your start button or you can hit the articles on the
Microsoft website:
http://msdn2.microsoft.com/en-us/library/ms130214.aspx

--
Keith Kratochvil

Show quote

"Kamil Skup" <ks***@wp.pl> wrote in message
news:O9$myqgwGHA.4612@TK2MSFTNGP02.phx.gbl...
> how to restore database in SQL 2005
>
>