June 8, 2008 at 12:28 am
Hi,we are planning to install a 64-bit server.But there is a32 bit server already installed.There are some databases on this server.what is the best approach(backup & restore) or (attach &detach).If backup & restore.I need to take the full backup and log backup.and restore the full backup with no recovery and log with recovery,is this is the correct way or any suggestions??
June 8, 2008 at 7:05 am
Detach all your user databases and keep it in a safer location. Install 64 bit and attach all the user databases. The only difference between detach/attach and backup/restore is that detach/attach is quicker but involves downtime as the source database will not be available. Its enough if you restore the full database backup no need of transaction log backup..
[font="Verdana"]- Deepak[/font]
June 9, 2008 at 7:29 am
If downtime is ok for you then and am with Deepak ,Go ahead with detach and attach.:)
June 9, 2008 at 8:19 am
I've done this at least three times in the last 2 months. Detach and reattach works fine but make sure you have a backup just in case. Also, if you reinstall SQL (say to put x64 on it) and have your data files stored somewhere else besides the default location make sure you apply the right permissions to the folders they are in after the upgrade. Otherwise SQL might not be able to access the files.
Kendal Van Dyke
June 11, 2008 at 8:43 am
detach and re attach, also dont forget to script off your logins and take those across too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 11, 2008 at 9:31 am
I do Aggree with Deepak, use sp_revlogin SP to transfer logins from one server to other. before Detach and reattach the server.
MCP, MCTS (GDBA/EDA)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply