Viewing 15 posts - 3,031 through 3,045 (of 6,676 total)
SQLRNNR (8/3/2011)
Try the suggestions in this articlehttp://blogs.msdn.com/b/sql_protocols/archive/2006/04/28/585835.aspx
I just posted the same link on SQLTeam.com for the same question :w00t:
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
August 3, 2011 at 5:51 pm
Format it in your C# code, see: http://msdn.microsoft.com/en-us/library/8kb3ddd4(v=VS.100).aspx#Y480
There are standard date/time formats available, but this should give you a good idea on how to accomplish this in your code.
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
August 3, 2011 at 5:27 pm
Just wanted to add a couple of things to this. First, whether you build a script yourself or use one that someone else has provided - make sure 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
August 3, 2011 at 5:10 pm
ChrisM@Work (8/3/2011)
pwalter83 (8/3/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
August 3, 2011 at 4:59 pm
Can you run @@version for this instance?
Since you are running the Standard Edition - you will not have the option to lock pages in memory unless you are on 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
August 3, 2011 at 4:52 pm
What I haven't seen yet is the memory and CPU specs for the server. That will also have an effect on performance here.
For a database that large, I 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
August 3, 2011 at 4:30 pm
YSLGuru (8/3/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
August 3, 2011 at 4:17 pm
Just curious - how often are you going to be refreshing this environment? If it is going to be a regular scheduled activity I wouldn't bother with shrinking. ...
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
August 3, 2011 at 3:56 pm
danymorales17 (8/3/2011)
Thanks for the response. I been looking at LiteSpeed from Quest. It has Object level Recovery but I'm sure this is pricey.
Be aware that this is only...
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
August 3, 2011 at 3:54 pm
sree-879715 (8/3/2011)
Thank you again for your reply.
Now, could you help me in the linked server setup to Oracle.
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
August 3, 2011 at 3:52 pm
GilaMonster (8/3/2011)
Check in DTC what the state of the transaction is. Also, try a restart of DTS (not SQL, not the machine, just MSDTC), see if that fixes anything.
Gail, 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
August 3, 2011 at 3:43 pm
Another advantage to either option 3 or 4 is that you can test the whole process up to either renaming SQL Server or creating a DNS record to point 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
August 2, 2011 at 2:50 pm
Ninja's_RGR'us (8/2/2011)
Check out my full results 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
August 2, 2011 at 2:39 pm
laddu4700 (8/1/2011)
I am not sure whether I can ask a general question here, sorry I am posting in wrong place.
Who will write the end-user report scripts ( business logic based)....
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
August 1, 2011 at 8:38 pm
I am not sure I followed your different options - but, if you are looking at creating a new instance of SQL Server on a new system then that system...
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
August 1, 2011 at 2:39 pm
Viewing 15 posts - 3,031 through 3,045 (of 6,676 total)