Viewing 15 posts - 751 through 765 (of 1,157 total)
From the error messages it looks like the server is not able to connect to the Active Directory to validate the windows users. Also have a look at this article
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 21, 2010 at 12:06 am
Hi Aman,
Add an output file to the job step and it will give more clarity on the error message
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 20, 2010 at 1:42 pm
Here they are
SQL 2005
********
sysdbmaintplan_databases
sysdbmaintplan_history
sysdbmaintplan_jobs
sysdbmaintplans
SQL 2000
********
sysdbmaintplan_databases
sysdbmaintplan_history
sysdbmaintplan_jobs
sysdbmaintplans
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 20, 2010 at 1:40 pm
Microsoft best practice reads this
Do not run DBCC UPDATEUSAGE routinely for databases created in SQL Server 2005 or higher or on upgraded databases that have been corrected once by using...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 20, 2010 at 1:35 pm
Barkingdog (8/20/2010)
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 20, 2010 at 1:30 pm
Is there a way using t-sql to get the file size from the actual drive? Like when you use the 'dir' command at a command prompt, you can see the...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 20, 2010 at 1:07 pm
Here is one example.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 20, 2010 at 7:16 am
SQL Server 2008 cannot act as a Distubutor for SQL Server 2000 Publisher. See the version comparison here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 20, 2010 at 7:12 am
I dont think EMC Timefinder/BCV backups can be used for transaction log backups. It works more like a Copy Only backup
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 20, 2010 at 5:06 am
Add an output file to the job step. That file will have more details about the job run status
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 19, 2010 at 11:35 pm
Check if these posts help you.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 19, 2010 at 2:14 pm
Assuming that the script file names are static, please try storing them in a table. Construct the query something like @sql = 'sp_reg_script ' + scriptfilenamefromtable. Then use the exec...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 19, 2010 at 2:11 pm
This cannot be logged in the Error Log. Why not make use of the Default Trace? Refer this[/url]
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 19, 2010 at 1:59 pm
Quorum drive is required in Windows 2008 cluster as well. Please refer this and this
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 19, 2010 at 1:57 pm
In the SQL Server Error Log. Please try to go through the Books Online and SSMS
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 19, 2010 at 10:15 am
Viewing 15 posts - 751 through 765 (of 1,157 total)