Viewing 15 posts - 4,441 through 4,455 (of 6,676 total)
free_mascot (10/22/2009)
The only reason what I am looking is that you have already purchage 32bit sql licence and having the new 64bit hardware.
There is no such thing as a 32bit...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 23, 2009 at 7:51 am
fizzleme (10/22/2009)
Licensing and availability issue. I agree it is best to use 64 bit for both products.I'll see what we can do about this.
Not sure what you are referring...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2009 at 7:31 pm
No concerns - other than why would you want to do that? There are only a very few specific reasons for running 32 bit SQL Server on x64. ...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2009 at 2:37 pm
Download and install SQL Compare from Redgate (fully functional trial version). Then, create a new blank database in production and perform a comparison between the database in development and...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2009 at 1:50 pm
Yes you can - but the real question is why do you think you need to? There are very few reasons that you would need to do that.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2009 at 1:48 pm
Dugi (10/22/2009)
I know this fact but...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2009 at 1:46 pm
I am going to say that it is not going to be possible - at least with the information you have posted so far. Please review the article I...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2009 at 1:38 pm
When I run into these kinds of issues, I write it out using psuedo-code then convert it to the function:
If invoice date is greater than 75 days from today, then...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 21, 2009 at 3:23 pm
The best option is another server - that will offload the processing completely and remove any contention between the production system and reporting.
Be aware that creating a new database, even...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 21, 2009 at 1:53 pm
PiMané (10/21/2009)
that's weird... was that an upgrade from an instance of a previous sql server version?Pedro
That would definitely cause the problem you were seeing. Each schema would have had...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 21, 2009 at 11:28 am
repent_kog_is_near (10/20/2009)
Thanks for your input on the RO DBs. yes, RO has it's downfall, but some of the good features that would work for us are RO featured...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 20, 2009 at 4:33 pm
Now you can validate whether or not instant initialization has been set up. If SQL Server is running under a domain service account that is not a part of...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 20, 2009 at 4:11 pm
GilaMonster (10/16/2009)
GSquared (10/16/2009)
Of course, if that particular page was affected by some transaction in the lost file....
As far as I'm aware, it doesn't matter. With a missing log file, the...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 20, 2009 at 3:59 pm
Are those tables in a different database? If so, then you would have to create the user in the other database and give them access in that other database...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 20, 2009 at 3:51 pm
Yes, if you are going to be altering the database in any way - that is going to eliminate a lot of possibilities and make the process much harder.
You can...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 20, 2009 at 3:38 pm
Viewing 15 posts - 4,441 through 4,455 (of 6,676 total)