December 11, 2011 at 8:55 pm
I have a client I'm doing some work for and they asked me if I could help migrate a db from one host to another. Figuring that I've done this in the past, I said "no problem" and was handed the task.
Here's the problem: The source db was built using an evaluation copy of SQL Server 2008, and the eval period has expired.
Normally I'd just use SSMS to move it from one host to another, however I can't because I can't even start the server because the eval period has expired. Is there a way to move the db without using SSMS i.e. copying files or something like that?
I'm not a dba, faaaaaar from it, but I've had to move databases between hosts and, using SSMS, have done so successfully.
December 11, 2011 at 9:40 pm
If SQL Server is not running you should be able to copy the mdf/ldf files to the new host.
December 12, 2011 at 6:48 am
And after copying the files use ATTACH to get the database set up on the new server.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply