Viewing 15 posts - 2,941 through 2,955 (of 6,676 total)
If you can confirm that the database is no longer (or never was) involved in replication, you can disable the replication (sp_repl_done). If that doesn't work, Gail has an...
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
November 25, 2011 at 12:08 pm
Well, I don't know if that would work or not - seems like it would, but you are also referencing a geo-cluster which is a bit different.
Either way, to upgrade...
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
November 25, 2011 at 11:59 am
salliven (11/25/2011)
Hello!You are check both server and tables and columns collation.
How will this change the fact that SQL Server will return rows in whatever order it deems is best -...
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
November 25, 2011 at 11:54 am
Peter Brinkhaus (11/25/2011)
Jeffrey Williams 3188 (11/25/2011)
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
November 25, 2011 at 10:46 am
george sibbald (11/25/2011)
by shut down the passive node I believe jeffrey means pause the node via cluster manager
Nope, means exactly what I stated. Shut down the node - power...
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
November 25, 2011 at 10:42 am
Fail the instance over to the node that is not upgraded - shut down the passive node and then apply the service pack to that node.
If you don't shut down...
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
November 25, 2011 at 10:05 am
Gianluca Sartori (11/25/2011)
wuze_ (11/25/2011)
But when...
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
November 25, 2011 at 10:01 am
This is one of the reasons why it is not recommended that you use '*' in production code. When you modify the underlying tables, the views will not reflect...
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
November 25, 2011 at 8:30 am
Just a thought - if you have the window to kick the users out of the system for some time.
1) Perform a full backup...just to be safe
2) Set database 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
November 24, 2011 at 8:02 am
ammo-963576 (11/22/2011)
With your SSIS project approach, are you able to get the package to log to the existing maintenance plan tables in MSDB? And have Management Studio recognize 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
November 23, 2011 at 2:58 pm
Evil Kraig F (11/22/2011)
On a side note, I'm...
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
November 22, 2011 at 2:07 pm
I wouldn't say I was a proponent of #3 - just that it can be done. I worked with an individual who set this up using VBScript - and...
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
November 22, 2011 at 12:48 pm
Just got back to this - and Gail answered for me, thanks.
I use a custom utility that deletes files based on the number of full backups I want to keep....
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
November 22, 2011 at 12:37 pm
What would you do if the database was corrupted right before your backup? And you didn't catch it before the next transaction log backup was run?
What would happen id...
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
November 22, 2011 at 5:46 am
Chris Metzger (11/21/2011)
For example, my trans logs grow regularly. I have SQL backup just the trans logs every 2 hours. Then as part of the maintenance plan (another...
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
November 21, 2011 at 11:51 am
Viewing 15 posts - 2,941 through 2,955 (of 6,676 total)