Viewing 15 posts - 4,531 through 4,545 (of 6,676 total)
Another option would be to set the database you want to connect to in the Registered Servers portion of SSMS. Then, every time you want to open a new...
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
October 2, 2009 at 8:08 pm
I have to ask, are you performing regular and frequent transaction log backups? If not, then that is the first thing you need to get working - before 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
October 2, 2009 at 8:02 pm
Well, you just about wrote it 😉
If NA1 is less than booking date then Appt1 is NA1 date
If NA1 is greater than booking date -system shouldnt allow that to happen
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
October 2, 2009 at 3:47 pm
jez.lisle (10/2/2009)
Okay, can the NA dates be less than the booking date? Are the NA dates NULL or empty strings if they don't have a date?
Yes the NA dates could...
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
October 2, 2009 at 1:56 pm
Okay, can the NA dates be less than the booking date? Are the NA dates NULL or empty strings if they don't have a date?
If the dates are NULL...
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
October 2, 2009 at 9:41 am
I am sorry, but I am not following the logic here. What happens if your NA column is not the same as appt1? What if the booking_date is...
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
October 2, 2009 at 7:39 am
First, is there a particular reason for wanting to stripe your backups? Are you trying to reduce the amount of time it takes to perform the backups?
If so, have...
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
October 1, 2009 at 2:40 pm
Are you moving/copying the backup files to other storage (e.g. tape, another server, usb drive, etc...)?
If not, then you really need to think about your restore options and what 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
October 1, 2009 at 2:36 pm
What you were doing in SQL Server 2000 was incorrect - you should never schedule a truncate of the log (breaks the log chain), or schedule a shrinkfile or shrinkdatabase...
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 30, 2009 at 1:57 pm
Thanks Matt - now we'll see if this works for the OP.
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 29, 2009 at 5:26 pm
Okay, I worked through each one and modified the expression - here is the result:
Select ad.uprn As HRN
,sv.completion_date As CompletedDate
...
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 29, 2009 at 4:37 pm
I reformatted the code a bit, so I could really see what is going on...
Select dbo_address.uprn As HRN
,dbo_service.completion_date As CompletedDate
...
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 29, 2009 at 4:15 pm
Greg Snidow (9/29/2009)
GSquared (9/29/2009)
The first thing I'd do with this would be to switch to ANSI style joins
I got into a bad habit of using commas for joins, until 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
September 29, 2009 at 3:58 pm
gmamata7 (9/29/2009)
Is better to move system databases ldf files to the original location where they installed for the first time?? If yes, I will go head and do that..please advice
As...
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 29, 2009 at 12:41 pm
For cluster configurations, this is how I set things up:
S:\ drive contains system databases (all files, mdf and ldf)
G:\ drive contains user database data files
L:\ drive contains user database log...
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 28, 2009 at 5:49 pm
Viewing 15 posts - 4,531 through 4,545 (of 6,676 total)