I agree with the view. If the Global Temp table us not used in multiple sessions, we should use the local temp tables only. Even it is advisable to use...

Hi,

You can have the Weekly Full Backup in place. But along with this I would suggest you to have atleast daily Transaction Log backup everyday evening sometime. This will minimise...

This is strange. The database does not online in such a case. Did you check with detailed activity logs ?

Your question is not very clear. Did you check the size of Tempdb and free space on Disk ? Still I don't see any big issue such.

Hope this may help you.

http://www.sqlservercentral.com/articles/SSIS/62678/

Duplicate posting.

If your database is backed up every night/day, it may be possible that there are some Maintenance Plan or direct Job for taking the backup. Check if you have...

Duplicate postings. Please avoid such incidents.

If your database is backed up every night/day, it may be possible that there are some Maintenance Plan or direct Job for taking the backup....

If your database is backed up every night/day, it may be possible that there are some Maintenance Plan or direct Job for taking the backup. Check if you have any...

Normally for exporting data from SQL Server to Excel one would use DTS (SQL 2k) or SSIS (SQL Server 2005). For some reason if at all you want to do...

You can use the Book Online for SQL Server to find the best possible answers of your queries. Someof the helpful links are:

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

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

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

You need to start a fresh for best result in your case. First restore the latest Full Backup files recovery as a base and then if any latest Diffrential Backup...

Hi Sameer,

Please post your questions separetly and properly so that people can try to help you.

Thanks, Atul

This seems that the OS is not able to determine the domain administrator privilege for executing the job. You should make the one system user with SA privilege as owner...

You only need

BACKUP DATABASE [TEST] TO DISK = N’D:\BACKUP\TEST.BAK WITH INIT

or

BACKUP DATABASE [TEST] TO DISK = N’D:\BACKUP\TEST.BAK

So simple. 🙂

You simply need

BACKUP DATABASE [TEST] TO DISK = N’D:\BACKUP\TEST.BAK WITH INIT

or

BACKUP DATABASE [TEST] TO DISK = N’D:\BACKUP\TEST.BAK

So simple. 🙂