berhanem 9188 (8/12/2013)
Dear SSC team,I hope your day is going well. I am tasked to move SQL Server 2008 DB, 2TB, which is in Simple Recovery Model, from local disk to a SAN, and it is on Developer Edition. The compatibility level is 90, I do not know if it will affect moving the database. It goes without saying NO DOWNTIME is allowed. Any suggestions? I have been considering backup/restore as an option.
Thanks for your response.
Dan.
I think the challenge is having no downtime, it sounds like you will be moving to a new server?
You can do as you stated "back up and restore the DB to it's new location by using "MOVE" command within your restore t-sql to assign new path. In SSMS you should be able to do the same, but that would take longer than t-sql due to time navigating the interface.
However moving to a new server-you will have to consider things such as user logins/jobs/ssis packages/etc.. so you will need to restore the rest of the dbs, with exception of tempdb. If you are only moving the User DB (it does sound like you are moving a completely new server?), you will have to gather all the information for DB logins, you can do that by writing or finding a script that will help you.
If you run a google/bing search there should be websites full instructions.
--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully 😀