callahan
Wed Mar 05 14:34:25 CST 2008
Just out of curiosity, what versions of SQL are you using? Was the first
server using SQL (2000 sp4 or 2005?) or was it using the database engine
installed during the typical, single server install of WSS 2?
If you were using SQL 2000 or 2005, and you are just adding the databases to
the same version of SQL elsewhere, then you could just attach them (which
uses the MDF
files and expects associated LDFs).
If the databases have not moved, they are still on the server, then I think
I need clarification as to what your question is.
Bottom line is you can add databases to SQL by attaching them, rather than
restoring them. Once you've attached them and they show up in the console,
then you can add the correct accounts as owners, etc.
Does that help?
-callahan
"Eric Chez" <eric.chez@gmail.com> wrote in message
news:374167ff-fd5e-4995-a5f0-c13cdf5d5007@e6g2000prf.googlegroups.com...
This would not work, as it requires the SQL backup version of the file
which i don't have. What i have are the raw mdf and ldf files from
the old server. Any other suggestions?
On Mar 3, 11:23 am, "Megan Brown" <mbr...@qmbearings.com> wrote:
> Try following the steps
> here:
http://technet2.microsoft.com/windowsserver/WSS/en/library/eb0fd0b4-0...
>
> "Eric Chez" <eric.c...@gmail.com> wrote in message
>
> news:14e31e3d-7bd0-42e2-824b-05a10bf5d7c1@d4g2000prg.googlegroups.com...
>
>
>
> >I recently had to reinstall a server that hosted a sharepoint site.
> > All i have are the MDF and LDF files (not a sql backup)
> > I'm trying to restore to a new server.
>
> > I tried creating a new database with the same database name (STS_ES01)
> > as the previous one, and replace the new mdf and ldf it created, with
> > the old one, but get a database suspect in sql 2000. how do i replace
> > the database owner and get the database online, so that i can access
> > it in sharepoint services server v2.?
>
> > thanks.- Hide quoted text -
>
> - Show quoted text -