Viewing 15 posts - 1 through 15 (of 98 total)
I would suggest you to understand a few things here which are ofcourse related with you business needs and ofcourse if see some gap between the backup strategies and the...
May 27, 2011 at 12:01 am
try this..
sp_msforeachtable 'sp_helprotect null,null,null,''?'''
Sachin
May 26, 2011 at 1:19 am
sqlstar2011 (5/24/2011)
is there a way to tell how many logs is sql server standby behind on?thanks
It is very tricky one for me . I have tried different combination finally did...
May 24, 2011 at 10:59 pm
Vertigo44 (5/24/2011)
After installing a service pack updates I am told that a restart of the server is required to complete the installation.
At this point can I...
May 24, 2011 at 10:32 pm
Joy Smith San (5/22/2011)
If I manually assign static IPs to all the named instances in my sever, then Don't I need to start the Browser Servervise .? Browser Servvice...
May 23, 2011 at 1:35 am
shiv-356842 (5/22/2011)
Hi Gail,But some body says we will truncate the table in primary database automatically it will truncate in secondary database is it True ?
How is it possbile..
Thanks
Yes, it...
May 22, 2011 at 9:40 pm
I suspect that you have case sensitive collation on that server. could you pls check the server collation.
Regards,
Sachin
May 18, 2011 at 11:02 pm
Pls. read out the attached PDF file. When i say normalisation in the context of query execution phases it is different from the normal normalistion which you must have learnt...
May 16, 2011 at 10:47 pm
I totally agree with gail. Now it is near impossible to re-generate your data. That is why we always stress on backups. Not only backups but restorable backups before you...
May 16, 2011 at 10:32 pm
Did you get some errors after executing the DBCC checkdb.
May i know why did you executed DBCC checkdb with allow_data_loss option. As Gail mentioned above this was the last resort....
May 16, 2011 at 9:02 pm
When you create any procedure,trigger or function or even a view , it only parses that object . Parsing is the first phase which only checks the syntax of the...
May 16, 2011 at 8:41 pm
As per my understanding Default language applies when you create the login.
So, try using Alter login command to change the default language for that login.
Regards,
Sachin
May 12, 2011 at 9:05 pm
muthukkumaran (5/12/2011)
harsha.bhagat1 (5/12/2011)
2. There was a differential backup taken yesterday night and I took one more differential backup on the same device.
Have you checked the filelistonly ? How many files...
May 12, 2011 at 5:20 am
I totally agree with Leo . If you see from a bigger perspective everything we do on a database has a risk involved with it . So this is where...
May 12, 2011 at 3:17 am
Viewing 15 posts - 1 through 15 (of 98 total)