Viewing 15 posts - 5,566 through 5,580 (of 6,676 total)
The IP address is controlled by the machine hosting SQL Server, unless you are using a cluster. In a cluster, the cluster group containing that instance of 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
March 11, 2009 at 2:33 pm
What are the sizes that you are seeing? Include the sizes for the backup, all data files (mdf/ndf) and the log files (ldf).
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 11, 2009 at 2:29 pm
Dave Mason (3/10/2009)All the db files are enabled for autogrowth by 50 MB.
Okay, so how large are the databases now - and is an autogrowth of 50MB large enough? ...
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 10, 2009 at 3:12 pm
In addition to what Gail has mentioned, how much space is available in the data file? Do you have enough space available to rebuild indexes - or, do 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
March 10, 2009 at 2:56 pm
Change your order by to a group by, and use sum:
SELECT Company,
Year,
SUM(CASE WHEN Quarter...
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 10, 2009 at 2:50 pm
SQL ORACLE (3/10/2009)
I know someone set it incorrectly. I know I have to change it (to virtual IP). What I would like to do is collect input what impact 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
March 10, 2009 at 2:45 pm
SQL ORACLE (3/10/2009)
Richard M (3/10/2009)
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 10, 2009 at 12:36 pm
The virtual IP address will not change. The users connect to the virtual IP address and not the node specific address. Cluster administrator redirects the virtual IP address...
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 10, 2009 at 10:47 am
I don't think there is anything to be fixed. When SQL Server is running on node 1 - it uses the IP address for that node. Cluster Administrator...
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 9, 2009 at 3:32 pm
bill (3/9/2009)STEP 2 (Conditional on STEP 1 being successful): BACKUP LOG sample_db TO sample_DbLog WITH INIT
As soon as you issue the above command, you can no longer restore to 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
March 9, 2009 at 9:37 am
I may be missing something - so please correct me if I am wrong, but don't you need to specify which server you are going to connect to and whether...
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, 2009 at 5:25 pm
You can use a case expression:
UPDATE dbo.Person
SET City = CASE Extension
...
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, 2009 at 5:29 pm
Harold Buckner (3/6/2009)
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, 2009 at 2:09 pm
Well, I would have to guess that this information is stored in the SSIS package. You would have to export the package and open it in BIDS to verify...
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, 2009 at 3:41 pm
another shot in the dark - but, run the following and let me know what you find:
SELECT * FROM dbo.sysoriginatingservers;
SELECT * FROM dbo.sysoriginatingservers_view;
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, 2009 at 12:26 pm
Viewing 15 posts - 5,566 through 5,580 (of 6,676 total)