Viewing 15 posts - 4,051 through 4,065 (of 6,676 total)
Steve Jones - Editor (3/8/2010)
Do you have a 64 bit reference? I haven't seen this.
Even on 32-bit machines, with 2GB of RAM, I haven't seen SQL Server starve the OS....
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
March 8, 2010 at 3:58 pm
I am not familiar with Veritas clustering, but it sounds like this is an issue with how that is working. On Microsoft clusters, you would reference the VIP instead...
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
March 8, 2010 at 2:31 pm
Looks like you have a process that is running at the same time as this step in your maintenance plan that is dropping that table.
When the maintenance plan starts, it...
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
March 8, 2010 at 2:23 pm
sureshdeenu (3/8/2010)
Here I am actully looking to copy my .bak file to a network drive once the backup was done, I want use xp_cmdshell to copy the files
You really 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
March 8, 2010 at 2:16 pm
Steve Jones - Editor (3/8/2010)
you might want to read...
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
March 8, 2010 at 2:09 pm
The two previous posts answered the question - if you need additional help, let us know.
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
March 8, 2010 at 1:48 pm
If the default trace was running when the object was deleted, you can look in the trace file and find when and who dropped the database.
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
March 6, 2010 at 9:28 pm
simflex-897410 (3/5/2010)
Thanks a lot Jeff.
Your queries beg one question.
So, the only reason you used this -> getdate()) +...
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
March 6, 2010 at 9:26 am
simflex-897410 (3/5/2010)
All I am trying clear up (for my current and fututre benefit) is that in a situation such as mine, where a fieldname is of DateTime...
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
March 5, 2010 at 7:15 pm
simflex-897410 (3/5/2010)
Are you saying that just being of dateTime datatype, that last code you wrote would work even though, there is no...
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
March 5, 2010 at 6:56 pm
There is this tool: http://sqlh2.codeplex.com/
On SQL Server 2008 - you can also implement and use the data collector to monitor multiple systems.
There are other free tools available at the above...
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
March 5, 2010 at 10:42 am
tluker (3/5/2010)
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
March 5, 2010 at 10:35 am
Unfortunately, unless your column is defined as a date data type (only available in SQL 2008), then you do not have a date. You have a string representation 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
March 5, 2010 at 9:09 am
The download will include all of the tools available in the toolkit. There are two tools that you would be interested in for this project:
SQL Compare
SQL Data Compare
The first...
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
March 5, 2010 at 8:27 am
Shark Energy (3/4/2010)
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
March 4, 2010 at 7:41 pm
Viewing 15 posts - 4,051 through 4,065 (of 6,676 total)