Viewing 15 posts - 2,956 through 2,970 (of 6,676 total)
SSIS would be a very simple setup:
You would need a data flow task. in the data flow, you will have an OLEDB Source and an OLEDB destination.
For the source,...
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
November 19, 2011 at 8:49 am
Wow, all these great titles - and all I am is simply the fireman. Well, at least that is all I every seem to to is put out fires.
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
November 19, 2011 at 8:36 am
You can export the SSMS maintenance plans and put them into a BIDS SSIS package. Then, you can modify the connection strings, backup paths, etc... and Save Copy 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
November 19, 2011 at 8:26 am
There is a standard report delivered with SSMS call Schema Changes History Report. Run that report and if the information still exists in the default trace it will show...
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
November 19, 2011 at 8:15 am
Perry Whittle (11/18/2011)
In my...
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
November 18, 2011 at 12:47 pm
I am surprised that an automatic page repair wasn't performed, since this database is mirrored.
http://msdn.microsoft.com/en-us/library/bb677167.aspx
Gail, any idea on why this wouldn't have fixed the problem already?
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
November 15, 2011 at 12:56 pm
Lowell (11/14/2011)
select [Years] = datediff(year,0,ET-ST)-1,
[Months] ...
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
November 14, 2011 at 3:18 pm
You need to work with the Exchange admins to find out why those addresses are blocked. This is not an issue with SQL Server.
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
November 10, 2011 at 2:19 pm
I wouldn't recommend removing the system supplied schemas. Since those schemas are owned by the principals associated with them, you would have to modify each principal and define a...
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
November 10, 2011 at 2:17 pm
Nadrek (11/10/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
November 10, 2011 at 2:11 pm
Simple answer: No...
The credentials you use to login to SQL Server have no bearing on the credentials being used by the backup. The backup will run in the context...
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
November 4, 2011 at 2:22 pm
For most systems, I will setup a single domain account per SQL Server instance and run all services under that account.
Only on systems where there is a requirement to make...
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
November 3, 2011 at 1:01 pm
Jeff Moden (11/1/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
November 2, 2011 at 1:14 pm
If you are using parameters on the procedure, there should be no need to validate the data length or data type.
For example:
CREATE PROCEDURE dbo.MyProcedure
...
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 30, 2011 at 8:14 am
Although not required - I would recommend patching to the latest patch level for each instance before installing the next. 2005 is at SP4 and you should have at...
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 28, 2011 at 12:14 pm
Viewing 15 posts - 2,956 through 2,970 (of 6,676 total)