脱机的、文件级的备份，用于备份完整的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 ...

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 ...

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 ...

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 ...

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, ...

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.

To me, the biggest surprise announcement coming out of Microsoft's Connect() 2016 conference last week wasn't that Microsoft was joining the Linux Foundation. Instead, it was that SQL Server Next ...