Viewing 15 posts - 166 through 180 (of 210 total)
Log Shipping is fairly easy to script out yourself as well.
You can find several homegrown log shipping scripts online that perform the same functionality however do not require enterprise edition...
January 27, 2005 at 3:47 pm
Standard compression utilities typically have problems with files larger than one or two gigs. Simply try to run a huge file through winzip and not only will it take...
January 27, 2005 at 3:45 pm
Rather than using DTS to copy data to a "backup" file, I would recommend using SQL's builtin backup functionality. Combining full and transaction log backups into a backup strategy...
January 26, 2005 at 11:38 am
You also may have a huge transaction log. A full backup takes a backup of the data file and the transaction log. TLogs should never grow as large...
January 25, 2005 at 1:55 pm
Even though its on a shared network make sure that you have permissions to the network drive and folder that the backup file sits in.
You can try an xp_cmdshell 'dir...
January 21, 2005 at 8:36 am
Not that I know of... the best way to reduce restore time is to get faster disks on your data drive subsystems. Either faster disks or more disks on...
January 17, 2005 at 2:38 pm
LiteSpeed also has their own enterprise management console that allows easy restores of protected backup files.
One thing to keep in mind with native password protected backups. Even though the...
January 15, 2005 at 9:43 pm
You should be able to either remove it via add/remove programs or you can do a system rollback.
January 7, 2005 at 7:43 am
Imceda Software has a product called Speed IDE that does exactly what you are looking for. You can put any object in your database (sp's, table schema, permissions, views, etc...)...
January 6, 2005 at 12:30 pm
Sounds like you've got a corrupted data file. You should consider restoring your most recent backup to rectify the problem.
December 22, 2004 at 2:55 pm
You should be able to just kill the process. I've killed backups several times in the past with no ill effects.
December 22, 2004 at 2:52 pm
You can also parse through the SQL Server error logs to check for failed backups. If a backup or restore operation failed, an entry will get written into the...
December 19, 2004 at 9:20 pm
Here is a link (from 1 year ago) that documets the largest databases sitting on SQL Server. While this is a year old and I personally know of many more...
December 16, 2004 at 4:27 am
Don't you specify port number in the .opt file that TDP uses. I think there is a *.opt file that includes connection strings used to specify how the client connects...
December 14, 2004 at 8:52 pm
I use procedures similar to the ones listed above. Be careful if you use maintenance plans to delete old files. I've found the way they do it to be fairly...
December 1, 2004 at 10:31 am
Viewing 15 posts - 166 through 180 (of 210 total)