Viewing 15 posts - 1,426 through 1,440 (of 4,745 total)
Bring the database online.
apply the last log available to you with the recovery option, or just run
restore database mydb with recovery
You may also need to resynch logins, activate agent jobs,...
October 26, 2011 at 4:04 pm
As for identifying fragmentation the windows defrag tool can obviously do that, and tools such as diskkeeper will give you more options.
I am not sure if they tell you which...
October 26, 2011 at 4:00 pm
Ninja's_RGR'us (10/26/2011)
george sibbald (10/26/2011)
if you restore the backup to somewhere with contiguous space, the data file will be contiguous.
So the fragmentation of the file after restore depends on the free...
October 26, 2011 at 3:48 pm
no.
if you restore the backup to somewhere with contiguous space, the data file will be contiguous.
So the fragmentation of the file after restore depends on the free space of the...
October 26, 2011 at 1:53 pm
Gus, no problem, it was just how your final sentence
'In summary, turn off log truncation. You don't need it, don't want it, and it can (will) break your backup chain'
read...
October 26, 2011 at 1:48 pm
jared-709193 (10/26/2011)
george sibbald (10/26/2011)
Gus, I don't see that, you want log truncation, otherwise the log will just continue to grow.
I believe this is wrong. When a log backup is...
October 26, 2011 at 12:57 pm
its the account that the SQL services are running under.
this could be local system, network service or a domain user set up for the purpose.
Check in SQL configuration manager to...
October 26, 2011 at 12:53 pm
Gus, I don't see that, you want log truncation, otherwise the log will just continue to grow.
I think the vendor is still wrong here, their software should be able to...
October 26, 2011 at 12:44 pm
You must run SQL Agent of at least the secondary server (but preferably both) under a service account - that is a domain user account. That type of account will...
October 25, 2011 at 3:35 pm
thank you pmonschein, thats an improvement.
I have been too restrictive in my last select statement in specifying view definition, so just replace that select with your statement. As the proc...
October 24, 2011 at 9:38 am
you can logship from enterprise to standard, or vice versa.
Just be sure you are not using any enterprise only features within the database you are logshipping, these would not work...
October 24, 2011 at 7:00 am
so it does. I told you not to open that can of worms. 🙂
October 24, 2011 at 4:23 am
going back a bit more I think it might have failed in SQL server 7. Been a long time though so not sure,
wouldn't be surprised if the vendor had ...
October 21, 2011 at 5:21 pm
GilaMonster (10/21/2011)
george sibbald (10/21/2011)
alexander.suprun (10/21/2011)
george sibbald (10/21/2011)
a max memory setting of 118GB is the buffer pool only, other SQL caches will add to that.george, where did you get this?
experience, lots...
October 21, 2011 at 5:15 pm
The vendor may be thinking of a limitation in SQL2000 which was removed from SQL2005 on.
does not excuse the vendors advice though.
proof:
http://sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-16-Concurrent-log-and-full-backups.aspx
October 21, 2011 at 4:33 pm
Viewing 15 posts - 1,426 through 1,440 (of 4,745 total)