I have 200 GB of SQL Server files I need to copy over a 100 Mbit connection. Assuming maximum throughput that will take five hours. SQL Server files compress very well, generally in the 80 - 90% ...
I have local drive in my system. The file system in my drive is NTFS. Some days ago I compressed my drive by disk cleanup for releasing free space. But when I want to attached my sql database with ...
I've been having a hard time copying large database backups from the database server to a test box at another site. I'm open to any ideas that would help me get this database moved without having to ...
I have two instances of SQL Server 2005 STANDARD edition, Server A in New York and Server B in California. Server A has a large database; for DR/BCP purposes, I would like to use Log Shipping to keep ...
Is there a nice way to have SQL Server 2005 run nightly backups that are automatically zipped with only the last n backups kept? I know the agent can perform nightly backups, but I think the tricky ...