Viewing 15 posts - 691 through 705 (of 1,157 total)
Looks like the GUI has a restriction of 256 characters for the email field. However you can also add the operator using T-SQL and it works.
USE [msdb]
GO
EXEC msdb.dbo.sp_add_operator @name=N'OperatorName',
@enabled=1,...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 8, 2010 at 11:12 am
As replied earlier by Ashish, your code does not overwrite the existing backups. Modify it to something like this
BACKUP DATABASE 'Datbasename'
TO DISK = 'EnterAStaticName'
WITH NOFORMAT,INIT, NAME = N''Datbasename'-Full Database Backup',
SKIP,...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 7, 2010 at 11:05 am
This post has some answers
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 7, 2010 at 11:02 am
There is no 64 bit Oracle ODBC drivers. Please refer this
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 7, 2010 at 10:58 am
This helps you getting started.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 7, 2010 at 10:51 am
Failing over the resources would confirm if the change has gone well with SQL Server or not
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 4, 2010 at 6:32 pm
What is the job designed do? What is the error message with which the job fails?
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 4, 2010 at 10:53 am
Check if the database files are compressed. If yes remove the Compression option in the Operating System. Refer this
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 4, 2010 at 10:32 am
You may find this information useful.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 1, 2010 at 10:59 pm
Here is the one for SQL Server 2005.
SELECT d.name, MAX(b.backup_finish_date) AS last_backup_finish_date
FROM master.sys.databases d
LEFT OUTER JOIN msdb.dbo.backupset b ON d.name = b.database_name AND b.type = 'D'
WHERE d.database_id NOT IN (2,...
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 1, 2010 at 10:48 pm
You may find this discussion useful
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 1, 2010 at 7:54 am
You should have got that option. Not sure though how it did not
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 31, 2010 at 10:26 pm
You would have got a screen which looks like this. May be you have skipped that.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 31, 2010 at 9:51 am
My 2 cents. It will not put database into SUSPECT mode.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 30, 2010 at 10:32 am
Access from SQL Browser? The error message in the event log may be due to the fact that some other application/user is trying to access with the wrong "sa" password.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 30, 2010 at 10:25 am
Viewing 15 posts - 691 through 705 (of 1,157 total)