Viewing 15 posts - 4,906 through 4,920 (of 6,676 total)
Review the article I link to in my signature to get a better understanding on how to manage your transaction logs.
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
June 29, 2009 at 8:08 pm
The problem is clear - you can only upgrade to SQL Server 2008 Express, unless you installed Advance, which is then upgradable to Workgroup.
What you can do is upgrade to...
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
June 29, 2009 at 8:05 pm
There is nothing special about configuring log shipping in a clustered environment compared to a standalone instance. They are setup/configured the same way.
Here is your starting point: http://msdn.microsoft.com/en-us/library/ms188698(SQL.90).aspx
Your problems...
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
June 29, 2009 at 7:50 pm
JC (6/29/2009)
Hi Jerryanother question
are those tempdb files 2 thru 8 suppose to be .ndf files instead of .mdf files ??
Thanks
Jim
The generally accepted naming standard is to name secondary data files...
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
June 29, 2009 at 3:06 pm
As George has stated, there are no reason to have that option enabled. Turn it off - and also (as George stated) turn off auto shrink if 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
June 29, 2009 at 3:02 pm
JC (6/29/2009)
I am looking at your code for tempdb files
I am new to sqlserver 2005
Not up to speed on TEMPDB files yet
i understand the creation of the multiple tempdb#.mdf...
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
June 29, 2009 at 2:22 pm
What that message tells me is that you have the database set to auto close. That means the database is closed when nobody is accessing it anymore and 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
June 29, 2009 at 2:17 pm
Krasavita (6/29/2009)
2.How to check Instant File Initialization?
3.This for Logs:
EnableAutoGrowth set to true
FileGrowth set to true by 10%
RestrictedFileGrowth set to 2,097,152 MB
4.This...
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
June 29, 2009 at 12:32 pm
Are you looking at running update scripts? Or, is this only going to be selects? If only selects, and you are running Enterprise Edition you can create a...
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
June 29, 2009 at 12:19 pm
If the database is set to full recovery model, you MUST run frequent transaction log backups. How frequent they are run will be determined by your business requirements. ...
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
June 29, 2009 at 11:02 am
The DATEDIFF function in Reporting Services is not the same function we have in SQL Server. It is the equivelant VB.NET function. Although it does work 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
June 29, 2009 at 10:57 am
If you are not running Vista or Windows Server 2008 - the provisioning option at the end of SP2/SP3 can be safely ignored.
On either of the above OS's - if...
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
June 29, 2009 at 10:50 am
Chris (6/29/2009)
Oh boy,, Now I've done it.My apologies to the forum.
I'm running SQL 2005 Ent.
Sorry all
Chris...
No problem, but that does mean you probably had an issue with copy/paste 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
June 29, 2009 at 9:20 am
Scott Duncan (6/28/2009)
In my experience with SQL Server 2005, SQL Server won't backup to a drive unless it is added as a dependency to the SQL Server service.
Not...
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
June 28, 2009 at 6:50 pm
I would probably approach this a bit differently. It would require an additional downtime, but I think it would be worth it.
1) Remove second node from cluster
...
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
June 28, 2009 at 12:03 pm
Viewing 15 posts - 4,906 through 4,920 (of 6,676 total)