Viewing 15 posts - 286 through 300 (of 1,179 total)
Other things are working fine? If server is not starting post the complete error log from start so that someone can help.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 6:18 am
Yes, this is possible as mirroring is specific to individual database and not specific to server.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 6:12 am
First find out from where data is comming? Depend on the application and design it could be possible to grow data 1GB/DAY. Also find out what kind of data is...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 6:07 am
As per your requirement and setup you can perform ALTER INDEX on object level for specific index or for all indexes. Also you can perform REBUILD or REORGANIZE.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 5:58 am
Have you checked msdb..backupset?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 5:51 am
Looks like domain user do not have permission on workgroup.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 4:53 am
You can test your current virtual backpu by restoring on test server or anyother non-production server to make sure in crisses when backup is require you can able to restore...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 2:47 am
If I understand correcly than you are just changing hardware excluding SAN storage; I guess SAN will take care of all the possible things. As your system and user datafiles...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 12:09 am
Good one, thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2014 at 11:47 pm
Yes you can do it by SSIS and with script too refer following link for script:
http://support.microsoft.com/kb/918992
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2014 at 4:34 am
It is not possible to recover database without backup.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2014 at 2:54 am
Interesting question, thanks.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 8, 2014 at 11:45 pm
Perry Whittle (4/8/2014)
free_mascot (4/6/2014)
From the security and connectivity perspective it would be good to keep sql servers on domain.
Not necessarily, security can still be implemented effectively on workgroup computers, it's...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 8, 2014 at 10:39 pm
As mention by Grant first decide what would you like to monitor? And then look for tool which suits your requirement.
Both the tool mention (Redgate and SQL Sentry) are...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 8, 2014 at 5:52 am
Looks like there might be permission issue. What error message you are getting when sending mail fails?
DatabaseMail.exe is external programme and use windows authentication. Refer following link which might...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 8, 2014 at 5:42 am
Viewing 15 posts - 286 through 300 (of 1,179 total)