June 3, 2011 at 3:48 pm
Hi all
I am new to here and just getting into SQL 2008 . Does anyone have any pointers or simple steps for me to import a database into a new installation of sql 2008. Also what to look out for so that I don't lose or mess anything up.
June 3, 2011 at 3:58 pm
Hi,
You can use sql management studio, connect to a database and right click on it, go to task and import.
Thanks.
June 6, 2011 at 4:12 am
if you mean from another server i would just backup and restore to your newly installed sql server.
June 6, 2011 at 4:29 am
WolvesAly (6/3/2011)
Hi allI am new to here and just getting into SQL 2008 . Does anyone have any pointers or simple steps for me to import a database into a new installation of sql 2008. Also what to look out for so that I don't lose or mess anything up.
Take a backup of your old server whatever database you want and restore it.
If your are going to restore all your database then look in google migrating a database
http://sqlserverblogforum.blogspot.com/2011/01/step-by-step-restore-using-t-sql.html
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply