Viewing 15 posts - 2,776 through 2,790 (of 3,061 total)
Chris Harshman (1/2/2009)
PaulB (12/31/2008)
Nice. I'm pretty sure your SOX auditors are loving it, isn't it?
Well, as I've stated previously I'm not really a .Net person, more a database person, so...
January 2, 2009 at 7:26 am
Mike Levan (1/2/2009)
What if some of the backups fail and how wud i re run job from that point of failure so that i dont need to run whole job...
January 2, 2009 at 7:20 am
Paresh Prajapati (1/2/2009)
I thik he is not taking transactional backup..
Exactly. That's why I'm asking if he's aware his backup/recovery strategy does not allow for point-in-time recovery. 😉
January 2, 2009 at 7:13 am
Looking at the provided information it looks like we are back to my initial answer, there is just one named instance in your system -no default instance shows up.
January 2, 2009 at 3:34 am
If that's the case I assume you installed your default instance AFTER installing named instances. There are a couple of well known issues when that happens.
Please check your registry for...
January 2, 2009 at 3:05 am
If I got your scenario right you do not have a default instance, you have just one named instance. That's why.
January 2, 2009 at 2:39 am
WayneS (1/1/2009)The differential backups are taking about 1-2 seconds, even at the end of the day. This way, I would only need to restore, at most, from 2 backup files......
January 2, 2009 at 1:57 am
WayneS (1/1/2009)So, why is the transaction log growing without any activity on the database?
On one hand I understand you expect not to have activity at those times but if transaction...
January 1, 2009 at 9:42 am
Here is what I'd do.
1- Add the new varchar2 column column_name_new as needed.
2- Populate varchar2 column with a simple update statement.
3- Rename old columns as column_name_old
4- Rename new column_name_new as...
December 31, 2008 at 9:55 am
Chris Harshman (12/30/2008)Well, we have to maintain and enforce security within our applications, instead of relying on Active Directory / Windows Authentication to dictate to the application what a users...
December 31, 2008 at 9:48 am
Chris Harshman (12/30/2008)... you will want to only have a few limmited number of SQL Server logins, such as: administrative user, standard user, readonly user.
I can see your organization...
December 30, 2008 at 11:34 am
metro17 (12/29/2008)
USE [DATABASENAME]
GO
ALTER TABLE [dbo].[EmpPers] ADD CONSTRAINT [pk_EmpPers] PRIMARY KEY NONCLUSTERED
(
[EepEEID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...
December 30, 2008 at 8:22 am
This is a SQL Server forum, your question about best practices for developing an application might get better answers in an applications related one.
In regards to the application backend -providing...
December 30, 2008 at 3:00 am
Saurabh Vegda (12/15/2008)
Actually i want to perform an inplace downgrade. Is it possible to downgrade it without doing uninstall and then re-install it?
No. There is no version downgrade procedure.
1- Take...
December 15, 2008 at 5:05 pm
Nicholas Cain (12/15/2008)
It's also excellent for getting rid of bugs
You made my day! 😀
December 15, 2008 at 7:56 am
Viewing 15 posts - 2,776 through 2,790 (of 3,061 total)