Re: SP Server Move - Which Files to Move?
Posted: Tue Jan 25, 2011 8:50 pm
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
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