SP Server Move - Which Files to Move?

Post Reply
Leo
Site Admin
Posts: 887
Joined: Thu Dec 11, 2008 7:52 am

Re: SP Server Move - Which Files to Move?

Post by Leo »

The nice thing about customers that don't do backups is that it give you something to do, inside, off a ladder.

I think you will need to run SQL commands to get the old database to replace the new SQL data.
the two files you need have a ext of MDF LDF - filename.mdf' filename.ldf'


I think this Article is what you need to do.
How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server
http://support.microsoft.com/kb/224071

SQL Server 2005 Command Line Tool “SQLCMD” – Part I
http://www.databasejournal.com/features ... rt-III.htm
ketlage
Posts: 3
Joined: Mon Oct 04, 2010 1:28 pm

SP Server Move - Which Files to Move?

Post by ketlage »

I have a customer that lost their Secure Perfect 6.0 Server/Client with no recent backups. I've got SP running on a new machine and I'm trying to pull data off the old hard drive for them.

Which files am I going to need to get the new machine running with the current database and config?

The last db backup file they have is from 2005. Classic.

Thanks
Post Reply