Viewing 15 posts - 5,146 through 5,160 (of 6,676 total)
RESTORE DATABASE ... WITH RECOVERY;
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
May 24, 2009 at 5:22 pm
Ally, no - the problem here was that Jamie was having a problem accessing the system resource database which is not referenced anywhere in startup procedures. The only way...
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
May 24, 2009 at 3:47 pm
Glad we could help and happy to hear that you have completed your integrity checks cleanly.
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
May 24, 2009 at 3:44 pm
saw of "Why is there never enough time to do it right the first time but there's always time to do it over?"
and over, and over, and over - until...
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
May 24, 2009 at 11:09 am
Powershell is not going to be very good at loading data - since it really is not designed for that. But, you can use powershell to build the bcp/bulk...
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
May 24, 2009 at 10:57 am
Just to follow up - you need to verify that you have regular transaction log backups being performed on your live server. My guess is that when you shut...
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
May 22, 2009 at 8:52 pm
Lynn Pettis (5/22/2009)
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
May 22, 2009 at 4:08 pm
I was going to show the convert method also, but Sergiy beat me to it. You could also use CAST as in:
CAST(Wages AS decimal(10,2)) / 100
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
May 22, 2009 at 4:05 pm
Here is what I did for those accounts:
In Windows - Local Users & Groups, I renamed each group to reflect the correct server. I then dropped the logins from...
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
May 22, 2009 at 3:49 pm
Be careful using NOT IN - there's a small little gotcha that you have to be aware of. If just one item can be returned as NULL, it is...
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
May 22, 2009 at 3:31 pm
The requirement, as far as I know, it that you cannot mirror from 2005 to 2008 or 2008 to 2005. As long as the databases are on the same...
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
May 22, 2009 at 3:24 pm
Saam Tariverdi (5/22/2009)
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
May 22, 2009 at 3:03 pm
Since these errors are showing up after upgrading from 2000 to 2005 - I am betting that they existed in 2000 also.
These types of errors are generally a result 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
May 22, 2009 at 2:12 pm
sam (5/22/2009)
Let me know if i say anything wrong.
Y can't the person take a full backup of all the databases manually and truncate 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
May 22, 2009 at 2:08 pm
If you have the /PAE switch set - then the first 3GB of memory would not be AWE memory and everything above that would be AWE. If this switch...
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
May 22, 2009 at 11:53 am
Viewing 15 posts - 5,146 through 5,160 (of 6,676 total)