It's going to represent the number of seconds, so the possible range is 00 to 59.

Let's say I have a backup of the current data filegroup from 10/1 and a backup of the archive filegroup from 7/31. Does that mean to do a...

GilaMonster (10/2/2013)

---

Warning: Since the DB is in simple recovery, you can take file and file group backups at different times, but you won't be able to restore them (unless all...

I have gotten mirroring to work between a SQL instance on a Server 2008 VM and a SQL Evaluation instance on the Host Windows 7 machine with 4GB installed, but...

If you have SQL 2008 Enterprise or SQL 2008 R2 Standard/Enterprise, you can use backup compression and run backups in less than half the time (in my experience) as non-compressed...

Look carefully through all the Agent jobs to see if there is a msdb transaction log backup command hidden somewhere. If that doesn't turn anything up try a server...

If you have SQL 2008 Enterprise or SQL 2008 R2 Standard or Enterprise you can make a compressed backup and move the data even faster.

When this was happening to me a trace did show the connection string that was failing containing the name a database that had been previously dropped, but there was still...

By "install SSIS" I mean the Integration Services checkbox in Setup.

So it sounds like it doesn't need to be on installed on the Database Engine server if a package is...

I would think that using anything to join tables that's not a unique key in at least one of the tables would be very risky.

So I don't need to rerun setup and add SSIS to the server, correct? I just need to make sure the SQLAgent account has permissions for everything the...

On a related note (similar software versions but the opposite range of RAM)

Windows Server 2003

SQL Server 2005

1GB Ram

How to best divide the 1GB of RAM between the OS and SQL??

It looks to me that SQLExpress installs as a named instance, therefore you must have SQLBrowser running to access it remotely. In SQL Server Coniguration Manager you can...

For exended reading, I still like hardcopy books. For reference, you can't beat the searchability of PDF files. PDFs are good on laptops and larger screen...

If you have available hardware/VM resourses, do one of your practice restores to a non production server just you yourself use and go wild on it. I find my...