Viewing 15 posts - 3,931 through 3,945 (of 6,676 total)
How did you copy the mdf/ldf files in the first place? Did you shut down SQL Server first - then copy the files? If so, then attaching those...
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 14, 2010 at 8:43 pm
Well, first of all you shouldn't be allowing your databases to autogrow. You should manually grow them out to at least 6 months of space and monitor the usage....
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 14, 2010 at 8:34 pm
In addition to what the others have stated, both Quest and SQL Backup utilize multiple 'threads' for the backup process - reducing the time it takes to backup in addition...
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 12, 2010 at 2:40 pm
If you want to create all logins from prod - then sp_help_revlogin would be the way to go. I didn't want all users on the prod system, so 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
April 10, 2010 at 9:00 am
First, you have to create the login on the secondary server with the same SID that exists on the primary server. Lookup CREATE LOGIN in BOL for exact syntax,...
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 9, 2010 at 10:04 pm
Yes, that's all you should need to do.
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 9, 2010 at 1:42 pm
Reorganize is fully logged, rebuild can be minimally logged when the recovery model is simple or bulk-logged. Either way, the transaction log backup after that operation will be very...
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 8, 2010 at 11:07 pm
george sibbald (4/8/2010)
whether...
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 8, 2010 at 10:07 pm
I did something similar using Powershell and SMO - you only need to install Powershell on your CMS server and use that instance to query all of the servers.
Or, you...
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 8, 2010 at 10:02 pm
Indianrock (4/8/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 8, 2010 at 7:38 pm
2Tall (4/8/2010)
That worked. However from the research I have done it appears I am unable to explicitly GRANT View to the users default database.Any thoughts,
Thanks,
Phil.
That is correct - deny supercedes...
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 8, 2010 at 5:59 pm
You have to put the AD group in brackets:
Deny View Server State To [DOMAIN\AD Group Name];
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 8, 2010 at 7:00 am
bodhilove (4/7/2010)
Ok you got me on that.Is there any disadvantage to let your data file grow continously? maybe fragementation
That would all depend upon what your IO subsystem is capable 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
April 7, 2010 at 10:00 pm
Paul White NZ (4/7/2010)Heh...so, I hadn't noticed that - I just saw the 2005 reference. Nevertheless, this is the 2005 forum, so maybe other people that read this thread...
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 7, 2010 at 9:55 pm
Why do you think you need to add another file? Are you having performance issues with the current file? How large is the file now?
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 7, 2010 at 7:56 pm
Viewing 15 posts - 3,931 through 3,945 (of 6,676 total)