Gourav, This is possible, as Avamar does it as part of its functionality. Catch is that it extracts the database/table/view/funct/sproc/etc schema of the database object itself and then does a select * from <table> command and formats the data into a Insert statement if you need to restore the data.
Although, i have seen it do over 2TB in under 4hrs, not including Log truncation, it is very querky about its backups. If you want to spend the time developing a process outside of SQL to do this, better not have anything else todo. As far as taking a backup of a database and not letting it log the transactions of the backup process, then change the database to Simple Recovery Mode and be done with transaction logs. Transaction logs really are only useful for Point in Time restoration of a database, so if last nights backup (full/incremental) is just fine with you then truncate/shrink the log files down to bare-bones, and then change the Recovery Model to Simple. On Jun 22, 5:19 am, Gourav <[email protected]> wrote: > Hi All, > > I want to know that can we Restore database of SQL SERVER without > using .BAK file. > Means can we use any specific Query to restore any specific date data. > I'll be waiting for your helpful reply. -- 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
