SQL Management Tools

  • Can the management tool needed to do restores and backups to a SQL2005 database be downloaded, and if so ... where can it be found?

    Thanks...

  • The main management tool I use for that is Management Studio. You can download the Express version from MSDN for free. The full version is on the SQL Server install media (assuming you have a version of SQL Server above Express), and you can install it on as many computers as you need to without additional cost.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Is the Microsoft® SQL Server® 2008 Management Studio Express able to manage a 2005 database?

  • Yes, you can connect to any SQL 2005/2000 database engine (not sure about the earlier versions) from SSMS 2008 Express.

    Follow this link for more details

    http://msdn.microsoft.com/en-us/library/ms365247.aspx

    --Ramesh


Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply