if you still want to use jobs to schedule scripts then use SQLCMD and Operating System schedule,make your script on SQLCMD and save as a batch file then schedule on...

Backup file drive and Restore File Drive is same ?

what is the size of Backup file now ?

Is there any Load on Database at the time of Restore ?

Regards,

Syed Jahanzaib...

Light weight pooling use when CPU usage is high and note it you cant use Linked Server connections if you will this pooling

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA...

Common files are installed on disk where windows installed in the program files

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

on which version you have created those SSIS packages

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

http://msdn.microsoft.com/en-us/library/bb933944.aspx

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

What is ACTIVE / ACTIVE failover node,is there any thing providing by microsoft,according to my knowledge there is no any active/active failover node in SQL Server.

ACTIVE/ACTIVE means 2 separate instances...

Yes,because he doesnt mention how many files and he mentioned files are 5GB restricted growth its mean each file have restriction of 5GB ,database size is cumulative size of files...

Database filegroup and files structure is ?

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

This flag is use for large page allocation from 2 to 16 MB

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

How did you create resource pool, this will change where you create resource pools,that is Resource Governor

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP...

SELECT o.[name], o.[type], i.[name], i.[index_id], f.[name]

FROM sys.indexes i

INNER JOIN sys.filegroups f

ON i.data_space_id = f.data_space_id

INNER JOIN sys.all_objects o

ON i.[object_id] = o.[object_id]

WHERE i.data_space_id = f.data_space_id

AND o.type = 'U' -- User Created Tables

GO...

Max Memory Set

1024 MB

106 MB

53 MB

53 MB

106 MB

106 MB

53 MB

53 MB

532 MB

Used Memory

14 MB

68 MB

2.4 MB

check this information,you have to change these setting for default

Regards,

Syed Jahanzaib Bin Hassan

MCTS |...

http://msdn.microsoft.com/en-us/library/ms189532.aspx

http://msdn.microsoft.com/en-us/library/ms147827(v=sql.90).aspx

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

you can break month wise and set partition function on month of 2011 like JAN,FEB,MAR then it will save these month data,in the next year 2011 no need to add...