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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-25 : 13:19:15
|
| Lawson writes "Hi:Are there any advantages of using SQL Server 2000 Backup over the Windows 2000 backup (of data/log files)? When restoring, I can select individual data/log files and attach them to the server.The only difference I saw was that Win2K backup will skip any files in use while SQL server backup will still copy these files. Since we shut down the server at midnight before backing up, this is not a problem.I read somewhere that SQL Server 2000 backup is better, but the article did not explain why. Please clarify.ThanksLawson" |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2002-06-25 : 13:30:08
|
| You will answer your own question, if you just read about different types of SQL Server backups, in SQL Server Books Online. SQL Server backup is the way to go.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
|
|
|
Backup: Win2K or SQL Server?