Viewing 15 posts - 3,916 through 3,930 (of 6,676 total)
jcrawf02 (4/21/2010)
And now for something completely different...
Any advice on ridding my lawn of 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
April 21, 2010 at 8:14 pm
Try rebuilding all indexes in that database - and then see if it reports different usage. I am not sure why your backup failed - did you ever check...
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
April 20, 2010 at 3:30 pm
Perry Whittle (4/20/2010)
Jeffrey Williams-493691 (4/19/2010)
there are times when using a local account is the right thing to do.in my opinion only when using a windows workgroup
I think we agree...
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
April 20, 2010 at 7:09 am
Well, you shouldn't be shrinking the database - it is just a waste of time since it will grow again.
What are the sizes of the mdf/ldf file?
What 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
April 20, 2010 at 7:07 am
prithvi-1147092 (4/19/2010)
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
April 19, 2010 at 10:22 pm
My recommendation: don't use devices, use files instead and let SQL Server date stamp each backup file. What it sounds like you are trying to do is manage 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
April 19, 2010 at 7:53 pm
Perry Whittle (4/19/2010)
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
April 19, 2010 at 7:35 pm
Bhuvnesh (4/19/2010)
Prithvi(4/18/2010)
what I did was to copy the Database from Mgmt Studio on the same server with a new DB name (oldname_new)and took a back of the new copied 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
April 19, 2010 at 2:45 pm
ananda.murugesan (4/19/2010)
when I am using sp_help_revlogin sql 2000 then after exec this script in
SQL 2008 DB all Login were automatically maped with particulare database, which was...
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
April 19, 2010 at 2:31 pm
Perry Whittle (4/17/2010)
The revlogin procedure will export the logins default database. OK if its master but if its a 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
April 17, 2010 at 5:24 pm
Your best option is to restore from backups, applying all of your transaction log backups up to the point in time of the failure. You do have a good...
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
April 17, 2010 at 5:10 pm
Perry Whittle (4/17/2010)
Jeffrey Williams-493691 (4/17/2010)
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
April 17, 2010 at 4:29 pm
A couple of points on your process:
Item 1: SQL Server service accounts should not be setup as local administrators. Whether or not you use a domain user or local...
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
April 17, 2010 at 9:34 am
You use the procedure sp_change_users_login with the auto login parameter and identify the login/user to be fixed.
Look up the procedure in Books Online for exact syntax and available parameters.
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
April 15, 2010 at 8:03 pm
Yes, definitely update to the latest service pack. And also make sure your client tools are at least the same version (if not greater) than any instance you are...
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
April 15, 2010 at 8:02 pm
Viewing 15 posts - 3,916 through 3,930 (of 6,676 total)