August 22, 2007 at 7:19 am
Hi,
I haven't understood people saying native mode while taking backups or restoring them. please some one help me the modes for SQL Serverbackups
August 22, 2007 at 7:54 am
Check out -n switch meaning 'native format' in bcp for doing bulk insert. But I have never head this used for backups.
August 22, 2007 at 12:59 pm
Here is a link. Maybe you know it already. My understanding is the backup on native mode is for Windows 2K or above.
http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=7156
August 23, 2007 at 2:47 am
I think people are trying to distinguish between standard SQL Server backup and restore (native mode) and using vendor products (Litespeed, Redgate, BMC, etc) to do backups.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
August 23, 2007 at 8:08 am
Ed is corrent. The "native" backups are made with native tools that ship with SQL Server. If you install Litespeed, SQL Backup, BMC's backup, etc., then you are working with a third party. Some of them can replace the BACKUP DATABASE command.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply