Viewing 15 posts - 5,491 through 5,505 (of 6,676 total)
This is not a problem with the databases - it is a problem with backing up across the network. If there are any issues with the network during the backup,...
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 26, 2009 at 12:08 pm
For those settings, I use a fixed size and not a percentage. What I try to do is pick a size that will allow for several weeks/months of activity....
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 26, 2009 at 9:23 am
First, you should be working in a development/test environment and testing your queries before ever getting them even close to a production system.
Next, you can wrap the process in 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 25, 2009 at 9:04 pm
When you attach the database to SQL Server 2005, the database engine upgrades the files. If it did not perform this upgrade - the engine would not be able...
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 25, 2009 at 8:56 pm
Okay - that is good. 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
March 25, 2009 at 7:34 pm
Lookup SHRINKFILE in Books Online, but here is how you would do it:
Use ReportServerTempDB;
Go
-- get the logical name of the file
Select *
From sys.sysfiles;
DBCC SHRINKFILE(logicalfilename, size);
Replace logicalfilename with 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
March 25, 2009 at 3:50 pm
The downside to this is that your procedure could only be run for a single server at a time. Trying to run it from multiple connections will cause problems because...
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 25, 2009 at 3:46 pm
How about using this:
ALTER DATABASE database_name
SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 };
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 25, 2009 at 3:02 pm
Florian Reischl (3/25/2009)
RBarryYoung (3/25/2009)
The Variable method is...
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 25, 2009 at 2:52 pm
Yes - on a failover you would have to manually configure those tasks to include the partner database.
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 25, 2009 at 2:46 pm
When reporting services is installed, the databases created use the default recovery model for that instance. Which is of course the recovery model defined on the model database -...
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 25, 2009 at 2:25 pm
Flo, with all due respect I think you are working too hard to avoid using a cursor here. Administrative tasks such as creating users in a set of databases...
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 25, 2009 at 2:16 pm
dallas13 (3/25/2009)
Here is my maintenance task on sql 2005 EE server1)backup all user databases
2)backup log for all user databases
3)reorganize index
4)rebuild index
5)update statistics
6)cleanup backup history task
First issue - you have...
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 25, 2009 at 2:11 pm
Don't drop the BUILTIN\Administrators group at all - just remove sysadmin access. Yes, this still allows public access to the instance, but does not allow access to the databases...
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 25, 2009 at 1:33 pm
Jerry - yes, you can specify the full address yourself because you are an administrator and have that ability. However, a normal user would not have that ability and...
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 25, 2009 at 12:35 pm
Viewing 15 posts - 5,491 through 5,505 (of 6,676 total)