Our normal practices for backing up SQL servers is to use the regular SQL backup tools to perform full, differential and transaction log backups and this has always worked fine. Recently we performed ...

There doesn't seem to be a 64bit x86 agent in BE 9.1! Well, there is a RANT64 agent but it looks like it is for Itanium machines.<BR><BR>I'm not even sure if BE 9.1 would backup SQL 2005. That's a ...

对多数数据库管理员和开发人员而言，安装与配置全新的SQL Server总令人充满期待，因为它意味着新的挑战与机遇。安装过程本身便是深入了解最新SQL Server版本的首要环节。本文将系统介绍SQL Server 2005实例环境的完整安装流程，涵盖从初始设置到当前服务包（SP1 ...

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Microsoft on Monday announced that Azure Backup for SQL Server had reached "general availability" status, meaning it's deemed ready for production-environment use. This service is used to backup SQL ...

在使用SQL Server 2005 Express Edition附加数据库时，常遇到无法升级数据库lk，因为它是只读的或含有只读文件的错误提示，导致数据库无法打开。经过实践验证，本文提供一种有效解决方法，已成功应用于实际操作中，可帮助用户顺利附加并正常使用目标数据库 ...