Viewing 14 posts - 76 through 89 (of 89 total)
I was able to remove the ActiveX components and replace them with SQL tasks. I keep the same...
November 10, 2004 at 9:21 am
July 26, 2004 at 6:23 am
June 2, 2004 at 6:03 am
The "with recovery" doesn't actually do a restore - it makes the database available for use. When the database is in stand-by mode, it's read-only and "with recovery" sets it...
May 27, 2004 at 7:08 am
Here's what we use for a similar purpose...
RESTORE DATABASE '<database name>'
FROM DISK = '<backup name>'
WITH STANDBY = '<uncommitted transaction file>'
contains the contents of data pages before uncommitted transactions...
May 27, 2004 at 5:23 am
In my organization, none of the practicing DBAs (I'm one of them) have any certification, but there are several developers who do have their certification but do not intend to follow...
May 13, 2004 at 5:38 am
We accomplish this by transferring full and log backups daily, and restoring them - setting up a "standby" server. We've setup a dts package that pulls the files from...
April 29, 2004 at 6:11 am
Check out - I use it and it works well.
http://www.sqlservercentral.com/scripts/contributions/763.asp
April 29, 2004 at 5:48 am
We've also had a lot of problems where mail would suddenly stop working. Generally, we would use xp_stopmail and then xp_startmail. Then magically (when talking about SQL mail that...
April 14, 2004 at 5:24 am
I do restores on a daily basis. If another user is connected to the database - whether or not they are actively using it, the restore will fail. There's...
November 26, 2003 at 6:54 am
We also use Winrar to compress the full backup of 18G database. However, the newer version of PKZip does support compression of files over 4G.
August 22, 2003 at 7:00 am
Here is a sample of a trigger used to insert records into another database when the rptflag field is updated. We select the necessary information from inserted and place...
July 10, 2003 at 7:03 am
Hi, Ron. Just a quick note to let you know that you can restore SQL 7 backup to a SQL 2K database. We do it daily in our...
April 21, 2003 at 9:26 am
Thanks everyone. I've rescripted the restores to use the NORECOVERY and RECOVERY options along with setting the database to read-only once the restores are completed. I was worried...
March 26, 2003 at 1:12 pm
Viewing 14 posts - 76 through 89 (of 89 total)