Viewing 15 posts - 31 through 45 (of 119 total)
Manoj (6/18/2008)
with init it shows you the %age how much got restored on the DB.
INIT just wipes any existing file, it doesn't have anything to do with the stats...
June 18, 2008 at 7:41 am
You can speed up network backups and restores by using multiple backup files. Backup/restore will (almost (TM)) always be slower over a network vs. a local drive.
BACKUP DATABASE Foo
...
June 16, 2008 at 2:37 pm
There is also the possibility that article Q304101 is coming into play...
Basically what the Q article references is running the source machine out of kernel-pageable memory space. You may...
June 16, 2008 at 12:03 pm
I had it installed (sort of) on a 2k3 cluster this morning. I'm having to pull it off and re-do it though as it defenitly wasn't working correctly...
Hopefully here...
June 13, 2008 at 3:54 pm
Verification happens by using a command other than BACKUP. That is what makes it feasible to be run on/with/from another server.
Since it's 2005, you can add the CHECKSUM option...
June 12, 2008 at 9:22 pm
Check your cluster networking and interconnects between the nodes. You might have some networking issues....
Can you define what's slow a bit more?
June 12, 2008 at 4:29 pm
Yes, using another server to perform a RESTORE VERIFYONLY is valid as it's using the RESTORE command and not the BACKUP command (gitit?).
I have to agree w/the other replies though...
June 12, 2008 at 1:19 pm
The code presented is actually about six months older than the date on it - I've been using this method on around 150 servers since it's inception with no issues.
Edit:
FWIW,...
June 11, 2008 at 10:04 am
TPC.org is a good place to learn about how people design highly scaleable systems. You have to be willing to wade through 500 page reports, but if you are...
June 10, 2008 at 8:25 am
Agreed. Something has either changed, failed or a competing process is running. I do similar nightly and my systems variance is under five minutes for the most part.
June 10, 2008 at 8:22 am
A day or so. I'm going to finish a current topic and then post the script in another entry.
June 10, 2008 at 8:20 am
SMO doesn't support drive enumeration...it's only relevant to SQL Server objects.
You'll need to use WMI or a FileSystemObject. I'll have a solution for this posted on my blog[/url] shortly...
June 10, 2008 at 8:12 am
ricfors (6/9/2008)
So, the Networker agent runs the sql scripts from the API instead of setting up SQL server backuping up to tape? Is that how it works?
For the most part,...
June 9, 2008 at 9:18 am
ricfors (6/9/2008)
I was wondering if there is any advantage backing up directly to tape than sql natively and then files to tape.
Are you referring to having the SQL server backup...
June 9, 2008 at 8:30 am
RETAINDAYS is a bit of a misnomer (IMO)... It ony prevents backups in a file from being deleted, yet there is no way to purge individual backups from a...
June 9, 2008 at 8:06 am
Viewing 15 posts - 31 through 45 (of 119 total)