Viewing 15 posts - 91 through 105 (of 473 total)
OS differences shouldn't matter.
But it looks like you're trying to restore a backup from a SQL2008 R2 (10.50.1600) server to a SQL2008 (10.00.1600) server which I'm pretty sure you can't...
November 10, 2010 at 1:01 pm
Are you trying to restore a full backup, or a log backup?
What's the exact message you are getting, and the command you are running to restore it?
November 10, 2010 at 12:35 pm
PFlorenzano-641896 (11/4/2010)
The compatibility mode is set to 100 on the SQL Server 2008 R2 server, and 90 on the SQL Server 2005 server.
I ran into different compatibility modes giving me...
November 4, 2010 at 12:59 pm
What happens if you use "mi" or "n" instead of "minute" for the interval argument?
November 4, 2010 at 12:19 pm
Just out of curiosity, why would you want to do this?
October 6, 2010 at 2:15 pm
Is there going to be a .pdf version of this book?
October 6, 2010 at 2:11 pm
I am no expert on compression. 7-zip does a great job when it comes to compression and it is open source too.
I've found 7-zip to pretty much be the...
October 4, 2010 at 2:53 pm
Gail - you zinged me yesterday for the same thing.
In this case and in mine, I think the questions were right in line with the thread.
Is it the fact that...
September 28, 2010 at 12:24 pm
Do you have a guestimate of the size of the database(s) you're talking about here?
September 27, 2010 at 2:55 pm
I know this is an old thread, but a question.
If you have a SQL job running DBCC checks, and a check finds an error, does it raise an error so...
September 27, 2010 at 11:59 am
They aren't really necessary in this example, but won't affect performance, and never hurts to use them.
You need to put the # sign inside the bracket though.
September 21, 2010 at 9:05 am
That will vary based on your environment, but the permissions should be the minimum required to still be able to get done what needs to get done.
September 13, 2010 at 12:11 pm
I'd forgotten all about this thread, sorry.
There were a couple of things that I found and tweaked that fixed our issue without adjusting any mirroring settings.
I finally figured out that...
August 9, 2010 at 6:18 am
Viewing 15 posts - 91 through 105 (of 473 total)