Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SaxMan101
Starting Member
2 Posts |
 Posted - 2007-01-24 : 13:36:58
|
| Here's the backup statement from a vendor supplied database.BACKUP DATABASE [PRODUCTION] TO DISK = @fullpathWITH INIT , NOUNLOAD , NAME = @name, NOSKIP , STATS = 10, NOFORMAT;@fullpath is a local disk, and @name is the database name + the current date. My question is about all the options. Most of them appear to be useless since the backup is going to disk, and each time this is run, the file name is different. Am I correct in this? Can this statement be rewritten to:BACKUP DATABASE [PRODUCTION] TO DISK = @fullpath WITH NAME = @name;and have the same effect? I don't care about printing messages as the DB is being backed up but like having the backup name in the backup table in msdb. Or am I completely misunderstanding the media header information?Thanks! |
|
|
|
|
|
Vendor supplied system backup