You need to restore FULL backup and latest DIFFERENTIAL backup. DIFFERENTIAL backup is cosolidated backup and capture all the pages changed since FULL backup.

HTH

Here is the small code which will help you:

DECLARE @d SMALLINT

SELECT @d = (SELECT Datepart("yy", Getdate()))

SELECT Concat(@d, '-', RIGHT(@d + 1, 2))

Instead of going through the many lines of code. You can achieve by using DATEADD function e.g.

SELECT GETDATE() -- This will give current date

SELECT DATEADD("HOUR", -6,GETDATE()) --This will reduce time...

It will not take fraction i.e. 1.5 hrs, instead you need to select 90 minutes.

HTH

Again standby mode in Log shipping will not allow users to use database and max you can have read_only database that too SQL removes the connection while applying the logs.

Do not use linkedserver for copy database. It will be security threat as users having access to test can access data on prod. And what if they think deleting in...

First try STOP JOB from JOB ACTIVITY MONITOR. Check the status of the job if it is rollback than wait else as a second option find session id and KILL...

refer the following link for compatibility matrix along with other info, however this is for 2008:

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

What is the size of database? how long it will take to complete full backup? Is your server prod?

In addtion to Gila, if set up incorrectly it may lead to performance issue on the server too.

Pl. find the extract from BOL:

"In SQL Server 2012, statistics are not created by scanning all the rows in the table when a partitioned index is created or rebuilt. Instead,...

Yes, you can use your e-mail address to test send the messages. There should not be any issue.

Yes, that is the tricky things in SQL Server 2000. While delete you need to put proper path and extention of file should be BAK not .BAK

Try and update the...

What is the size of Data & Log file?

Make sure installation files of SQL Server are not corrupt. Also best way is to restore from previous backup as mention by Gila.