![]() You do not have to know the SQL commands to use this tool. For everyday use, a fat client may seem more appropriate. ![]() This small tool is useful and allows not to have to install a fat client for occasional use. This SQL viewer online allows you to make SQL online test, you can SQL practice online.Thanks to sharing mode, you can be several to test an online SQL database. This example returns information about the second backup set ( FILE=2) on the AdventureWorksBackups backup device.This SQLite viewer allows you to open SQLite file online in order to create, query, and edit SQLite database files.It is useful for developers wanting to query a database file,it can help test and debug data from a sqlite database.This SQLite playground can also be useful for non-developers. Using Transact-SQL To view the data and log files in a backup set Look in the Database files grid for a list of the data and log files and their properties. Right-click the database, and then click Properties, which opens the Database Properties dialog box. Using SQL Server Management Studio To view the data and log files in a backup setĪfter connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.Įxpand Databases, and, depending on the database, either select a user database or expand System Databases and select a system database. For more information, see GRANT Database Permissions (Transact-SQL). ![]() ![]() In SQL Server 2008 (10.0.x) and later versions, obtaining information about a backup set or backup device requires CREATE DATABASE permission. To view the data and log files in a backup set, using:įor information about security, see RESTORE FILELISTONLY (Transact-SQL) Permissions This topic describes how to view the data and log files in a backup set in SQL Server by using SQL Server Management Studio or Transact-SQL. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |