Viewing 15 posts - 406 through 420 (of 1,179 total)
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 3:38 am
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))
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 3:22 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 2:57 am
It will not take fraction i.e. 1.5 hrs, instead you need to select 90 minutes.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 2:45 am
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.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 1:29 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 25, 2014 at 1:22 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2014 at 10:47 pm
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2014 at 10:42 pm
What is the size of database? how long it will take to complete full backup? Is your server prod?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2014 at 6:11 am
In addtion to Gila, if set up incorrectly it may lead to performance issue on the server too.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2014 at 6:07 am
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,...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2014 at 6:04 am
Yes, you can use your e-mail address to test send the messages. There should not be any issue.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2014 at 5:35 am
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2014 at 5:34 am
What is the size of Data & Log file?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2014 at 12:43 am
Make sure installation files of SQL Server are not corrupt. Also best way is to restore from previous backup as mention by Gila.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
March 24, 2014 at 12:35 am
Viewing 15 posts - 406 through 420 (of 1,179 total)