Viewing 15 posts - 586 through 600 (of 1,179 total)
Nice one... good to recall old days SQL 2005 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 11, 2013 at 5:28 am
Time for the backup also vary depending on the processes going on the server. There might be some temporary blocking while taking the backup which may inturn increase the time...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 5, 2013 at 2:18 am
The actual number of user connections allowed also depends on the version of SQL Server that you are using, and also the limits of your application or applications and hardware....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
November 5, 2013 at 2:10 am
In addition, attached script also can be handy for backup and restore. However little modification is required as per the requirement. This is for log backup you can also use...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 30, 2013 at 7:36 am
Just to clarify further...
Only if you didn't apply any Tlog backup your diff backup will work. Differential backup can't be apply on secondary server if subsequent tlog backups have successfully...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 30, 2013 at 7:26 am
Find another link in addition to the above. This is perfect way to do step by step troubleshoot of database mail:
http://technet.microsoft.com/en-us/library/ms188663(v=sql.105).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 30, 2013 at 7:11 am
Execute following command:
select * from msdb..sysmail_faileditems
This table contain single row for each failed items.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 30, 2013 at 7:06 am
Like the basic question.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 28, 2013 at 12:07 am
Indeed a great one!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 21, 2013 at 7:19 am
Good easy one.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 21, 2013 at 12:10 am
As explain by Gila it is not possible.
However if your all backup and everything are fine and still if you have the same problem there might be possibility that someone...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 15, 2013 at 3:55 am
Here is the technical description of Checkpoint pages/sec: "Indicates the number of pages flushed to disk per second by a checkpoint or other operation that require all dirty pages to...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 11, 2013 at 1:16 am
Agreed with Jeff, it all depends on the desing of the LUNs.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 10, 2013 at 4:37 am
Redgate, ignite, SQL Sentry
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 10, 2013 at 4:35 am
Check for stored procedure to fix orphaned users or fix user login which may help. Or create a script of commands which manually you are executing on server to fix...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 9, 2013 at 6:55 am
Viewing 15 posts - 586 through 600 (of 1,179 total)