Viewing 15 posts - 391 through 405 (of 832 total)
Start with the basics--if you run SQL Server Configuration Manager, does it show your local SQLEXPRESS instance under SQL Server Services? If so, is that service running?
February 29, 2012 at 4:10 am
Could be incorrect folder permissions--you certainly don't need to give the SQL service account local admin permissions on the server for log shipping to work. Difficult to say more given...
February 29, 2012 at 4:05 am
durai nagarajan (2/24/2012)
Hello,What are ther main reasons for log file growth.
IN my case we take only full back up daily, no log backup.
doesnt seams to be shriniking after backup.
If...
February 24, 2012 at 5:08 am
It's probably nightmares engendered from the days when the company I worked for were trying to run a separate virtualised SQL server for every project...once you get 12 of the...
February 23, 2012 at 8:36 am
Not an expert on Oracle but I found this FAQ about how to get the top N rows from a table:
http://www.orafaq.com/faq/how_does_one_select_the_top_n_rows_from_a_table
February 23, 2012 at 1:42 am
I agree with Gail, but for what it's worth, I think the calculation you're having so much difficulty with is designed to shrink the log file to a quarter of...
February 23, 2012 at 1:36 am
Does the collation actually make a difference here, or was that included as a bit of misdirection?
February 23, 2012 at 1:28 am
Of course, with your new setup, if you have a major physical drive failure you still need to reinstall whatever host OS you're using and put VirtualBox back on it......
February 23, 2012 at 1:25 am
jswong05 (2/22/2012)
If you are already local administrator, why don't you just use DAC. See BOL if you don't understand DAC.
Correct me if I'm wrong, but that would only work if...
February 23, 2012 at 1:18 am
I also picked Yes and No, because the question about MODEL being read-only has come up before, so I knew it was possible to set it to read-only; but it...
February 22, 2012 at 4:04 am
Out of interest, what happens if you *TRY* to do a point-in-time restore to somewhere inside a log backup containing bulk-logged operations? It's not like you'll be able to determine...
February 21, 2012 at 4:28 am
peterob1 (2/21/2012)you need to stop the SQL Agent before you sign on in single user mode, or it will grab the allowed single user.
That would certainly make sense in my...
February 21, 2012 at 4:26 am
I agree with Koen--you can do a point-in-time restore in Bulk Logged mode so long as there are no bulk-logged operations at the point you want to do the restore...
February 21, 2012 at 1:16 am
Weird. I *have* had to do this a couple of times myself and it's worked fine...no idea why it didn't for you!
February 21, 2012 at 1:11 am
Koen Verbeeck (2/21/2012)
February 21, 2012 at 1:06 am
Viewing 15 posts - 391 through 405 (of 832 total)