Viewing 15 posts - 6,511 through 6,525 (of 6,676 total)
What version of SQL Server 2005 are you on? There was an issue in an earlier release where the Check Database Integrity Task would not actually run against all...
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
June 5, 2008 at 4:39 pm
You can use the properties 'LastBackupDate' (date of last full backup) and 'LastLogBackupDate' (date of last log backup).
I don't see anything available to identify a differential backup though, if 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
June 5, 2008 at 4:11 pm
Oh - I missed that little detail 🙂
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
June 5, 2008 at 2:54 pm
I agree - and that was my recommendation to the OP also. So, basically - we were saying the same thing...:)
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
June 5, 2008 at 2:47 pm
Select @@version returns the following:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on...
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
June 5, 2008 at 2:45 pm
How do you know what value in Row2 to associate with the value in Row1? How do you know that the value 2 belongs to the value 1 in...
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
June 4, 2008 at 3:51 pm
I am curious about something. If I followed what you were trying to do, you were trying to move the 'indexes' over to the new filegroup and leave 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
June 4, 2008 at 2:24 pm
How often do you run log backups?
How often do you rebuild indexes?
Are there any ETL type processes that run on a scheduled basis?
Jeff
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
June 4, 2008 at 2:16 pm
Again, yes - that is correct when you setup everything in a SQL Agent Job. Now, try setting that up to run as a maintenance plan and use 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
June 4, 2008 at 1:52 pm
The .ndf file is a secondary database file - which is defined in SQL Server for that database. I think your only option at this point is to restore...
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
June 3, 2008 at 6:14 pm
You don't need to create the database first. You can perform the restore from the .BAK file and the files will be created.
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
June 3, 2008 at 5:09 pm
Here is one way (of many):
Declare @len int;
Declare @value varchar(10);
--Set @value = '4567890';
Set @value = '1234567890';
Set @len = len(@value);
Select @value, stuff(stuff(right('000' + @value, 10), 7, 0, '-'), 4, 0, '-');
Jeff
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
June 3, 2008 at 5:05 pm
You will need to create a linked server between the two instances and use four-part naming (e.g. server.database.schema.object).
Jeff
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
June 3, 2008 at 4:54 pm
Here is one way:
-- Setup the variable for testing
Declare @value varchar(1000);
Set @value = 'select * from table 2 where something in (''a'', ''b'', ''c'')';
Select @value; -- this will look...
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
June 3, 2008 at 4:53 pm
GSquared (6/3/2008)
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
June 3, 2008 at 3:50 pm
Viewing 15 posts - 6,511 through 6,525 (of 6,676 total)