Viewing 15 posts - 241 through 255 (of 469 total)
Is your batch command being run from a centralised server..if so the error occurs only if the batch file is removed from there.
However, please post your error with some more...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 13, 2009 at 10:26 pm
Shrinkfile does not work every time. Find out why the log grew so big first then you can fix it. If you said you have the database in Full recovery...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 13, 2009 at 10:22 pm
GSquared (1/12/2009)
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 12, 2009 at 2:38 pm
GilaMonster (1/12/2009)
The_SQL_DBA (1/12/2009)
USE msdbSELECT TOP(30) OBJECT_NAME(object_id), rows
FROM sys.partitions
ORDER BY rows DESC
How's that going to find what's filled the transaction log up?
To check for any queues in the msdb on account...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 12, 2009 at 2:21 pm
USE msdb
SELECT TOP(30) OBJECT_NAME(object_id), rows
FROM sys.partitions
ORDER BY rows DESC
Run this and see if you can find any hints..
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 12, 2009 at 1:36 pm
This could be on account of a large DML operation overnight?
If that were to be the case, do you have transaction log backups running in the night too...my assumption is...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 12, 2009 at 1:33 pm
What version of SQL server is this?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 12, 2009 at 1:29 pm
Correction for 2005 Use this :http://msdn.microsoft.com/en-us/library/ms144256(SQL.90).aspx
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 2:06 pm
See this : http://msdn.microsoft.com/en-us/library/ms143393.aspx
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 2:01 pm
Is the login a user on the remote server? If not use option:
login using the current users security context and enter the login and password by going into the properties...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 12:50 pm
DBA (1/8/2009)
hi, don't worrry ask as many questions as you want, yes it is full with simple recovery model, i have both my Dbs as autogrowth, by 10% , unrestricted.
If...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 12:37 pm
tempdb on C drive..how big is the drive itself.
As a best practice place tempdb on a disk with high throughput, like a RAID 10.
Well, you can move tempdb to this...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 12:34 pm
If they are member of a Group in windows then take them of this group that way they can't login to SQL. Create an AppUser login with SQL Authentication and...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 12:22 pm
Per CPU is the most often used licensing type when it comes to big organizations..the more the CPU's the higher the cost
Ex: SQL 2005 standard supports only 4 CPUS -...
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 12:02 pm
Did you dig in on SQL Response?
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
January 8, 2009 at 11:45 am
Viewing 15 posts - 241 through 255 (of 469 total)