On Thu, Jun 23, 2011 at 4:00 AM, Rick Mcconnell <[email protected]> wrote:
> Stephen is not really correct in his statement - If the source data query
> was from another DB, then you could 'restore' data from the alternate DB.
> Gourav, I'm not sure if SQL server stores backups of itself within itself.
> You can query for 'log' info - table info, update info, etc. Perhaps
> describe a little more in detail what you are trying to accomplish.
> Thanks.
> Rick
-------------
The request was to RESTORE DATABASE.
RESTORE (Transact-SQL)
SQL Server 2005
Other Versions
Updated: 12 December 2006
Restores backups taken using the BACKUP command. This command enables you to:
Restore an entire database from a full database backup (a complete restore).
Restore part of a database (a partial restore).
Restore specific files, filegroups, or pages to a database (a file
or page restore).
Restore a transaction log on to a database (a transaction log restore).
Revert a database to the point in time captured by a database snapshot.
------------
Restore Database From the Command Prompt
If you are moving your data to a new server, or you have removed the
old database completely you can restore it using the code below. This
will only work if the database does not already exist:
mysql - u user_name -p your_password database_name < file_name.sql
Issue here is "Restore"
I thought that the request was to get the restore command text and how
to execute it from outside of SSMS.
--
Stephen Russell
Unified Health Services
60 Germantown Court
Suite 220
Cordova, TN 38018
Telephone: 888.510.2667
901.246-0159 cell
--
You received this message because you are subscribed to the Google
Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML
Web Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en
or visit the group website at http://megasolutions.net
