Opening Event Viewer and viewing events related to failover clustering

To open Event Viewer and view events related to failover clustering:

If Server Manager is not already open, click Start, click Administrative...

--Crude way

Try running below mentioned query and try to output only the latest execution of plan and you will get your data in columns named 'command' and 'line4'.

select * from...

Check sql server error log for tht message and once u get the correct 'State' in error message refer to http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

MJ

You can specify any name. If there is any format that you follow for mdf file names thn specify it in that format(under EM--Restore Database-->Options-->Restore As) while restoring.

http://articles.techrepublic.com.com/5100-10878_11-1041267.html

HTH!

Moin,

It is because its maintenance plan log table which logs every execution information. Would be better if you just order by end_time desc and check the first few rows(in ur...

SELECT [task_detail_id]

,[line1]

,[line2]

,[line3]

,[line4]--Displays Age: Older than 4...

Hope it works for you!

Manu

Thanks for sharing your experience Jeff.

Many thanks!

MJ

Try the attached one(zipped format).

http://www.martinfiala.net/Archive/2006/10/08/Zasilani-emailu-z-SQL-Serveru-bez-nutnosti-instalace-MAPI-klienta.aspx

MJ

Run exec sp_spaceused @updateusage = ‘true’

to get exact figures and then decide accordingly.

http://www.mssqltips.com/tip.asp?tip=1358

MJ

Thanks Lowell. That will surely help. Needless to say I find your scripts(posted on this forum) too useful.

Thanks again.

Manu

Yes, you can. Go to New Agent Job-->New Job Step-->Under Type-->choose Active X Script. In down window select VBScript as lanaguage and paste your script.

MJ

That 66.4 is available for use by other applications.

MJ

Run restore headeronly from disk='backupfilenamewithpath' and chk column named 'backup type' in output.

Backup type:

1 = Database

2 = Transaction Log

4 = File

5 = Differential

Database

6 = Differential File

MJ

Try running the job after changing the owner to 'sa' if its not sa. Also, try running the job step script manually under SSMS after logging in with user account...