Re: a database restore technique question...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Steve Lin (lins_at_nospam.portptld.com)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 09:30:51 -0700

"...copy over the old database files to the new..."
does that include system files such as master, msdb and so on?

if that's the case, wouldn't you need to 'attach' all the databases?

his tenique simple renamed the original directory to the new directory.

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:#cXyfpiJEHA.2412@TK2MSFTNGP12.phx.gbl...
> What he should have done was copy over the old database files to the new
> folder. It appears that perhaps the old executables got corrupted.
>
> --
> Tom
>
> ---------------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
>
>
> "Steve Lin" <lins@nospam.portptld.com> wrote in message
> news:%234$J1ViJEHA.1392@TK2MSFTNGP09.phx.gbl...
> background sql2k on nt4.
>
> one of the disk stripe went bad during the weekend and our network admin
> rebuilt the box and reinstalled sql2k w/ sp2 but he didnt' check what was
> installed origionally. his restore is like this:
>
> 1. origional sql excutables and database files are located at d:\mssql\,
he
> renamed it to d:\mssql_x\
> 2. he reinstalled sql2k and system databases to d:\mssql\, after that he
was
> able to start the sql service again.
> 3. he then renamed d:\mssql\ to d:\mssql_y\, and renamed d:\mssql_x\ back
to
> d:\mssql\
> but the sql service wouldn't start. he said that tenique worked a couple
of
> times at other occasions.
>
> my questions:
> 1. what might go wrong this time?
> 2. what's wrong with this technique, there is no backup or restore
involved.
> almost sounds too easy to be true.
>
> thank you.
>
>

Relevant Pages

  • Re: Deploying a SQL Server App
    ... Generally you don't want to deploy the database files per se (although SQL ... the database to the server. ... >> Instread of using connection strings that are hard coded into your ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: See last changes in sqlserver
    ... database files are effected, ... my database exist out of customer, product, order, company files/entity ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.programming)
  • Re: Trans log backup based on size rather than time?
    ... If the disk where the database files reside goes belly up, ... Is the bug only in 64 bit? ... Links for SQL Server Books Online: ...
    (comp.databases.ms-sqlserver)
  • Re: a database restore technique question...
    ... What he should have done was copy over the old database files to the new ... Columnist, SQL Server Professional ... rebuilt the box and reinstalled sql2k w/ sp2 but he didnt' check what was ... able to start the sql service again. ...
    (microsoft.public.sqlserver.server)
  • a database restore technique question...
    ... rebuilt the box and reinstalled sql2k w/ sp2 but he didnt' check what was ... origional sql excutables and database files are located at d:\mssql\, ... able to start the sql service again. ... what's wrong with this technique, there is no backup or restore involved. ...
    (microsoft.public.sqlserver.server)