Viewing 15 posts - 6,061 through 6,075 (of 6,676 total)
The_SQL_DBA (9/24/2008)
you can search books online for DBCC shrinkile or truncate log. For the time being use this which is very effectiveUSE DatabaseName
GO
BACKUP LOG DatabaseName WITH TRUNCATE_ONLY
DBCC SHRINKFILE(TransactionLogNameFileName)
Please do 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
September 24, 2008 at 2:24 pm
If you cannot figure out how to pass in a Null value - then, pick a value that will never exist in the data. I would probably go with...
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
September 23, 2008 at 2:01 pm
Right-click on the view in Object Explorer and script as CREATE to new query window. Change the connection or database in the query window to the system\database where 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
September 23, 2008 at 1:34 pm
First - are you sure you installed developer edition and not express edition? Second, what version of SQL Server did you install? The executable for the management studio...
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
September 21, 2008 at 10:49 am
Also, if your system is setup like most systems - then all of your objects are owned by the dbo schema. If so, you want to modify all users...
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
September 21, 2008 at 10:44 am
Not sure what you mean - are you sure your companies mail server is accessible from anywhere? Have you tried pinging the mail server from home to see 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
September 20, 2008 at 9:20 am
Create a role in the database, grant execute privileges on the appropriate schema to the role and add your users to the role. To grant execute privileges you would...
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
September 19, 2008 at 10:06 pm
Check out Melissa Data - they are fairly well known and seem to be reliable.
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
September 19, 2008 at 5:25 pm
Yes, you have to download it from Microsoft. I don't have the link - but if you search Microsoft for Performance Dashboard it comes right up.
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
September 19, 2008 at 3:13 pm
At work, you are connected to your companies LAN and have access to the mail server. From home, you are not connected to your companies LAN, and therefore 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
September 19, 2008 at 3:08 pm
As was mentioned previously, check the execution plans from both systems.
Just a guess, but I think you'll find that the difference in the execution plans is due 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
September 19, 2008 at 2:38 pm
If you were to upgrade to SQL Server 2005\2008 Enterprise Edition - you could then rebuild your index online. Well, actually that depends upon the table and index being...
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
September 19, 2008 at 1:34 pm
bmr270 (9/18/2008)
It is showingProduct version:8.00.2039(SP4)
When I check the version of SQL server in Query analyzer (@@version)
It is showing Microsoft SQL...
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
September 18, 2008 at 4:07 pm
shobana.rajaram (9/18/2008)
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
September 18, 2008 at 4:01 pm
And, what is the size of tempdb in your production system?
You probably should move tempdb to another drive that has enough space available. Is the disaster recovery system setup...
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
September 18, 2008 at 3:54 pm
Viewing 15 posts - 6,061 through 6,075 (of 6,676 total)