Viewing 15 posts - 3,721 through 3,735 (of 6,676 total)
Sorry - I misread this, thought you were moving from Production to Test.
Can you explain what you mean when you say you are losing your primary keys? I don't...
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 18, 2010 at 3:04 pm
You can use Backup/Restore to restore the whole database instead of just the data.
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 18, 2010 at 1:54 pm
These kinds of issues are generally related to a mis-match between the client tools and the version of the server. Validate the version of the client tools is 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
June 18, 2010 at 1:52 pm
Has this transaction log ever been backed up? Doesn't sound like it - which is why it is as large as it is.
At this point, I would recommend 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 18, 2010 at 1:46 pm
irene.leung (6/15/2010)
Thanks for the hint on maintenance plan creation.The issue is now resolved.
So, what was the problem and how did you correct it? Maybe someone else will come...
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 15, 2010 at 7:43 pm
Yes, you have 4 IP addresses assigned. One for each node of the cluster, one for the cluster group and one for the SQL instance.
From the server, open 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
June 14, 2010 at 11:34 pm
In a windows cluster, you have a Cluster Administrator. This cluster administrator manages the resource groups that have been defined for the cluster.
Each cluster group will be setup 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
June 14, 2010 at 7:56 pm
That is still the Job History and not the maintenance plan history. The maintenance plan history is going to tell you what task failed and why.
Based upon this message,...
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 14, 2010 at 7:49 pm
Instead of looking at the agent job history, you need to be looking in the maintenance plan history. Open the maintenance plan folder in Object Explorer, right-click on your...
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 14, 2010 at 7:00 pm
What are you confused about?
Yes, you can use the virtual IP address for any cluster group that is currently hosted on the same node to access that node through RDP....
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 14, 2010 at 6:59 pm
Error 5 is an access denied on the file. Make sure the user running SQL Server has full rights on the folder where the file exists.
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 13, 2010 at 9:32 am
What do you mean by locked? Are you getting an error?
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 12, 2010 at 1:31 pm
Since this will be a one-time operation, you can use SHRINKFILE to shrink the data file. What you'll have to do first is try rebuilding all indexes. 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
June 11, 2010 at 1:21 pm
sqlserver12345 (6/10/2010)
*
FROM Table1
WHERE
mydate =convert(varchar, getdate(), 111)
I am running this query in SSIS.I have data with todays date but I cant return the data with the above sql.It runs...
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 11, 2010 at 12:20 pm
Check the history for the maintenance plan instead of the job history. This will show you which task failed, and on that task you can get the actual error...
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 11, 2010 at 12:11 pm
Viewing 15 posts - 3,721 through 3,735 (of 6,676 total)