Live ISP Support direct from 123vISP Language
 
HomeKnowledge BaseHostingManagement of SQL 2005 database
Information
Article ID84
Created On10/20/2008
Modified10/20/2008
Management of SQL 2005 database

Management of SQL 2005 database

How do I backup/manage my Microsoft SQL 2005 database?

  • Note your database username and add "_dbo" to it; so "123x45678" becomes "123x45678_dbo"
  • Note your database password
  • Web based backup, queries and security
    • Go to http://www.mydomainname.com:8043/ (enter your real domain name)
    • Choose "SQL login" and enter the username and password above
    • See on-line help once logged in for more info
  • Total management using Microsoft SQL Server Management Studio Express (SSMSE)
  • Let us know if you have any questions...?