脱机的、文件级的备份，用于备份完整的SQL环境，备份前要停掉SQL的服务(MSSQLServer 和SQLServerAgent)，然后备份所有与SQL相关的文件(操作系统、SQL程序文件，SQL数据文件)。 Logical backup 联机的、数据库级的备份，不影响用户对数据库的访问。只能备份数据库中数据。

Here is a feature that I have been waiting for since I started working with SQL Server 6.5: the ability to script the data from a table. When you deploy a SQL Server database, you often need to ...

It's SQL Server 7.<P>It's a few development databases, and there are 3 people that may make changes throughout the day. I'm not exactly in charge, but I don't trust the other two people that are ...

So, I'm trying to update an sql script we use for dumping databases. I want to add a shrink to the script but it's not working and I don't really understand why. SQL is not a strong point for me. The ...

It appears that the long wait for SQL Server 2005—the successor to Microsoft's renowned SQL Server 2000—will be well worth it. SQL 2005 promises to be a polished, powerful product with significant new ...

How do I assign permissions to users to see SQL Agent Jobs? Your email has been sent You can give your users rights to check if reports have run or jobs are complete without granting full admin rights ...

When it comes to improving the performance of database systems, there are nearly as many approaches as there are DBA (database administrator) teams. That might sound acceptable at first glance. But, ...

Last week the Data Driver wondered if SQL Server was behind the recent Hotmail outage. The answer is: No. It was a script error, according to a Windows Blog post by Mike Schackwitz, pointed out to me ...

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.

Helping & empowering business owners for over 15 years, helping them to understand how to protect own interests, build bridges to amplify joint ventures, adapting new business practices and solutions.