Viewing 15 posts - 3,886 through 3,900 (of 4,745 total)
Then you should start off with the 4 files, baseline performance, then add the 4 new files and check peformance again.
Are all these files in the same filegroup? How do...
February 11, 2009 at 1:15 pm
only logically, via SSIS or script out and BCP. restore ar attach won't work.
February 11, 2009 at 1:00 pm
Linda Johanning (2/11/2009)
February 11, 2009 at 10:30 am
don't get this at all. I answered 1,4,5,7,8 and was amazed to get it wrong, so I have checked it using QA in 2000 SP4 and SSMS 2005 SP2, both...
February 11, 2009 at 8:15 am
'Virtual DEVICE' suggests a third party backup tool which does hot backups of the databases directly off the server. Is such a tool installed as part of your standard build?
These...
February 10, 2009 at 4:10 pm
you have taken a new full backup of the primary, yes?
copy that to the secondary,
the database now already exists on the secondary so when you restore over it you have...
February 10, 2009 at 3:43 pm
once you bring the secondary on-line you can apply no further tran logs to it, the db needs to be in recovery or standby mode.
Only one way -backup primary...
February 10, 2009 at 2:07 pm
thats good to hear. thanks for the feedback.
February 10, 2009 at 6:30 am
a value of 0 for AWE setting does mean it is disabled.
check this in query analyser with command: (run one line at a time)
exec sp_configure 'advanced options',1
reconfigure
exec sp_configure 'AWE'
exec sp_configure...
February 10, 2009 at 3:57 am
jbloes (2/9/2009)
Does it sound like I'm understanding the procedure correctly otherwise?
yes basically
Do both folders on each machine need to be shared?
don't have to be shares but...
February 10, 2009 at 3:43 am
MANU (2/9/2009)
Might be the rest of the memory is getting utlised by OS or other applications running on this server. I would suggest you to use /3GB switch.MJ
the /3GB switch...
February 10, 2009 at 3:30 am
see http://msdn.microsoft.com/en-us/library/ms188698.aspx
for the initial restore with norecovery of the full backup, do that step manually, results are not good if you leave that to the logshipping GUI. then take it...
February 9, 2009 at 4:13 pm
I'd have to disagree with that. The no of locks is a dynamic setting, if SQL requires more , it takes them, as each lock uses a bit of memory,...
February 9, 2009 at 7:40 am
Viewing 15 posts - 3,886 through 3,900 (of 4,745 total)