answersLogoWhite

0

go to sql command prompt.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How to backup sql database?

Use program way backup and recovery. Tool repair sql database any version starting with MS SQL Server 2000, including SQL 2005.-------------You can backup SQL server database using SQL Server Management Studio (SSMS), T-SQL or PowerShell.Limitation: Backup created using higher version can't be restored in earlier version of SQL server.


Where can someone find information about SQL Server Backup software?

Someone is able to find information about SQL Server Backup software at several different webpages online such as the following: the SQL Wikipedia page and the SQL website.


How does one back up their SQL server?

You must have Microsoft SQL Server Management Studio in order to back up your SQL Server. First you must open the software. Next you need to choose the database you wish to backup. Then you should name the backup and press ok. The backup should begin and backup to wherever you have selected.


How do you put SQL Server in hot backup mode?

Use the TSQL backup command to backup an active database.


Is it possible to obtain free SQL server backup software or does it have to be paid for If it can be obtained at no cost where is the best place to find it?

It is possible to obtain free SQL server back up software. Two sites which have it are SQL Backup and FTP and Iperius Backup. However, their authenticity and trustworthiness couldn't be verified, so caution should be applied.


Difference between sql server 2003 sql server 2005?

There is no such thing as SQL Server 2003. Microft released SQL Server 2005 as the next version of SQL Server 2000.


Should I take a SQL server class?

It could indeed be worthwhile for you to take a SQL server class. Ultimately, it depends on your profession and how much you interact with a SQL server. If it will improve your workplace knowledge I would highly suggest taking the class.


Introduction to sql server?

The nintroduction sql server is are the following


Where could one purchase a Sequel or SQL server?

The Sequel, or SQL, Server is owned by Microsoft. One can purchase an SQL Server from the Microsoft website. Microsoft also offers a free trial of the SQL Server.


Describe IDE of SQL Server 2005?

An IDE for SQL Server 2005 refers to an Integrated Development Environment for SQL Server 2005. This is a tool that can be used by a programmer to create and maintan a SQL server database. Some commonly used IDE tools for SQL Server 2005 are:SQL Server Management StudioTOAD for SQL ServerTOAD for Data Analysts


What is a SQL Server instance?

An SQL Server instance is a complete SQL server and you can install many instances on a machine but you can have only 1 default instance.


What has the author Louis Davidson written?

Louis. Davidson has written: 'Pro SQL Server 2005 Database Design and Optimization' 'Pro SQL server 2008 relational database design and implementation' -- subject(s): Client/server computing, SQL server 'Pro SQL Server 2005' 'SQL Server 2000 Stored Procedures Handbook (Expert's Voice)'