Viewing 15 posts - 7,246 through 7,260 (of 9,253 total)
So this is a backup that was taken with Redgate SQLBackup is that correct?
March 13, 2011 at 1:22 am
Sql Smith (3/11/2011)
The restore gets to 100%, but never actually finishes. I've used RESTORE VERIFYONLY to check the backup. It reports "The backup set on file 1 is...
March 12, 2011 at 12:50 pm
my guess is the passive node was actually the active node. If the service didnt restart you need to find out why the group did not failover correctly
March 12, 2011 at 12:39 pm
JKG (3/8/2011)
I found this really helpful: http://www.mssqltips.com/tip.asp?tip=1687
That guide's good, but mine's better 😉
March 9, 2011 at 12:40 am
rjohal-500813 (3/8/2011)
Perry Whittle (3/6/2011)
yes it is. message me an email address and i'll send you my guide
Any chance of turning this into a SSC article? I'm sure there are plenty...
March 8, 2011 at 9:36 am
suri.yalamanchili (3/7/2011)
My email address is suri.yalamanchili@gmail.com. I appreciate your help in providing the guide.Thanks,
Suri
Mahommed can you supply more info on the set up you were using?
What hypervisor software were...
March 8, 2011 at 8:46 am
no need for xp_cmdshell or any other nasties. Create a sql server job step as activex script and set to VBS. The code i use is as follows
Option Explicit
'Delete all...
March 6, 2011 at 1:10 pm
totally possible, ensure the new server is the same build\version
March 6, 2011 at 1:04 pm
SqlRandall (3/3/2011)
I've granted ALTER TRACE to the account, per BOL for that function, but to no avail. Any ideas?Thanks in Advance,
my guess is the domain account doesnt have permissions...
March 6, 2011 at 12:59 pm
yes it is. message me an email address and i'll send you my guide
March 6, 2011 at 12:47 pm
Non admin users have permissions on sp_configure to view SQL server configs.
March 5, 2011 at 3:04 am
Suresh B. (3/1/2011)
I don't think SQL Server restarts automatically when tempdb is full.
No, but starving the OS of memory will!
March 5, 2011 at 2:58 am
tuntun.oo (3/3/2011)
It gave me new trick.
After testing with new File Group and File at principal, mirroring works.
But, I cannot create database snapshot at mirror.
Before adding File, the following one...
March 3, 2011 at 3:03 pm
ha\dr that is the technology. You could also log ship with mirroring to create another database instance besides the mirror for reporting if you were really wanted to segregate your...
March 2, 2011 at 1:23 am
Viewing 15 posts - 7,246 through 7,260 (of 9,253 total)