Viewing 15 posts - 6,241 through 6,255 (of 6,676 total)
alorenzini (8/1/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
August 1, 2008 at 12:29 pm
ansz5 (8/1/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
August 1, 2008 at 12:45 am
You have to include the REPLACE qualifier to replace the existing database. Additionally, you may need to set the database into single_user to get exclusive access.
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
August 1, 2008 at 12:38 am
rfalagan (7/31/2008)
yes, remote connections are allowed.
And, what are the settings for this? It should be one of the following:
o Using TCP/IP only
o Using named pipes only
o Using both TCP/IP...
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
July 31, 2008 at 10:40 pm
Great - glad we could help.
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
July 31, 2008 at 10:20 pm
No, they need to be dependencies for SQL Server. You need to take SQL Server offline - add the drives as dependencies for SQL Server and bring 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
July 31, 2008 at 10:11 pm
Because a GROUP BY totals the set of data and OVER summarizes the data over the set. It's just the way it works. 😉
Here are a couple of options...
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
July 31, 2008 at 7:55 pm
Angelindiego (7/31/2008)
BEGIN
(SELECT
pl.LocationID AS PLocID
----->, @PRegionAbbrev = pl.RegionAbbreviation
----->, @PLocName = pl.LocationName
FROM dbo.Location pl
INNER JOIN dbo.Unit u ON pl.LocationID = u.PresentLocationID
)
END
I got...
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
July 31, 2008 at 4:35 pm
MarlonRibunal (7/31/2008)
Download here: http://www.microsoft.com/downloads/details.aspx?FamilyID=D07219B2-1E23-49C8-8F0C-63FA18F26D3A&displaylang=en
-Marlon...
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
July 31, 2008 at 3:51 pm
Nathan Davis (7/31/2008)
I found out a little additional info - the two...
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
July 31, 2008 at 3:44 pm
SQL Server has three recovery models. Each recovery model defines how transactions are dealt with in the transaction log.
Simple Recovery: transactions are cleared automatically so the space can be...
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
July 31, 2008 at 12:18 pm
No and No 🙂
You disable the indexes by issuing the command: ALTER INDEX indexname ON table DISABLE;
You truncate a table using: TRUNCATE TABLE table;
Now, if you have foreign key relationships...
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
July 31, 2008 at 11:34 am
drodriguez (7/31/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
July 31, 2008 at 10:58 am
Check the SQL Browser service and make sure it is running. This is required to be running when you have a named instance.
If you don't want the SQL Browser...
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
July 31, 2008 at 10:40 am
Your database are set to full recovery and require frequent transaction log backups to clear the log file. If you don't need to be in full recovery model, switch...
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
July 31, 2008 at 10:37 am
Viewing 15 posts - 6,241 through 6,255 (of 6,676 total)