Viewing 15 posts - 361 through 375 (of 1,065 total)
Probably just headers in the backup file saying which database it's from, details of the LSN it relates to etc etc.
October 12, 2009 at 4:02 am
Same here, just had a proposal from favourkarume12@yahoo.com
October 9, 2009 at 8:17 am
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
should do it... as long as you understand the potential pitfalls of doing this!!
October 9, 2009 at 7:21 am
jcrawf02 (10/9/2009)
Actually, that was fun, I followed that almost verbatim in Italian, and never taken Italian. 😀
Then you might be able to convince a prospective employer that you are fluent...
October 9, 2009 at 6:39 am
Both distributors are running under the same profile, and the only difference in their parameters is that the distrib for the remote subscriber uses SQL authentification (-SubscriberLogin + -SubscriberPassword), whereas...
October 9, 2009 at 4:05 am
ItalianOlgi (10/8/2009)
If I lose my job several times,ok, but if will not be forever
Don't be quite so smug about it... the SQL Server DBA community is not as big as...
October 9, 2009 at 3:34 am
Mark_Pratt (10/8/2009)
I was under the impression the once your restore with recovery, you cannot go back and start restoring from logs again. Never tried it though.
It is possible... it's something...
October 8, 2009 at 3:33 pm
A few more belated comments...
The client wants more than just a gold star and the comment about proving that the backups are working is 100% correct!
If the monthly restore...
October 8, 2009 at 11:31 am
Why are you going to restore a full backup once a month?
With log shipping, you usually do a full backup/restore once, and then keep the secondary up to date with...
October 8, 2009 at 3:19 am
Are you sure it's the actual deletion that is slow... what if you turn your delete statement
delete from ReportDetailTable
where ReportDetailTableID in (Some SubQuery, not to complex)
Into a SELECT statement
SELECT...
October 8, 2009 at 2:58 am
What you're seeing here is SQL Server doing a CHECKPOINT.
Have a look at this article for a description:-
http://msdn.microsoft.com/en-us/library/ms189573.aspx
As you are running in SIMPLE recovery, I assume you are willing to...
October 7, 2009 at 8:47 am
I guess your right. The work is certainly plentiful in the capital, although the idea of working there doesn't thrill me...!
Didn't thrill me either... I stood it just...
October 7, 2009 at 8:02 am
If the folder you are trying to use is the root folder where SQL Server was installed, have a quick look in Explorer... you may find it's marked as read...
October 7, 2009 at 7:58 am
Aah, I didn't think it would be that simple.
If you only want to verify that the data is there, then pause all the log shipping jobs and restore the last...
October 7, 2009 at 6:57 am
It may be nothing to do with the number of modifications, and you may be suffering from a "parameter sniffing" problem, where you end up with a cached plan that...
October 7, 2009 at 6:10 am
Viewing 15 posts - 361 through 375 (of 1,065 total)