Viewing 15 posts - 331 through 345 (of 812 total)
1) Are you taking the full backup or filegroup backup?
2) Do you have same database setup in some other environment/server where same database with filegroup exist? Like QA or Dev....
----------
Ashish
February 11, 2011 at 7:42 am
Please stop recommending that people look in the default trace for data changes. Data changes are not tracked by the default trace in any version of SQL.
then what is the...
----------
Ashish
February 11, 2011 at 6:22 am
Please follow this very well written article:-
Obviously, as mentioned in post as well, it will work only if your default trace is enabled which you can check by running :-
select...
----------
Ashish
February 11, 2011 at 3:54 am
its similar to restoring the database....not sure where you finidng the problem.
SSMS--rightclick on your database where u want to restore---tasks--restore--file and filegroups.
If you want to do this by script...
----------
Ashish
February 11, 2011 at 3:12 am
use msdb
go
select a.name as Jobname, a.enabled,
b.next_run_Date as [Next Schedule to Run],
b.next_run_time as [Scheduled time to execute]
from sysjobs a, sysjobschedules b
where a.job_id= b.job_id
This query will give you information on the jobs...
----------
Ashish
February 11, 2011 at 3:06 am
I've never heard of nolock causing blocking and deadlocks. Can you explain your understanding a bit more, please, as there must be a gap in my understanding.
I have experienced it...
----------
Ashish
February 10, 2011 at 4:08 am
No lock is suppose to speed up your queries because the overhead of locking is not happening. Also because nolock is specified deadlocks shouldn't happen. Please can you let...
----------
Ashish
February 10, 2011 at 2:44 am
funny to see that product can be named as ....dude.
So coming onwards whoever call me dude, I will tell them I am not microsoft prodcut. 😀 😀 :-D...
----------
Ashish
February 10, 2011 at 2:00 am
no, I will not suggest for nolock.
It will affect your performance very badly and you will see lot of blocking and deadlock as well.
----------
Ashish
February 10, 2011 at 1:54 am
it will be different SIDs for windows account which you will create in new domain
----------
Ashish
February 10, 2011 at 1:31 am
if you asking for decreasing the log file then the only thing you can do is more frequent log backup and execute small chunk of update/insert/delete statement.
Also Shrinking...
----------
Ashish
February 9, 2011 at 8:39 pm
What I am unclear on is the best way to handle the many Windows groups / user logins i.e [olddomain\bhope] that exist in the system.
Windows account you have to create...
----------
Ashish
February 9, 2011 at 8:32 pm
February 9, 2011 at 8:27 pm
ok, so it confirmed that its not orphaned account.
Next thing I would like to check if the account have correct permission on database level. Seems like as soon someone...
----------
Ashish
February 9, 2011 at 8:57 am
It need to be run in the database where you have the problem.
For more detail please have a read of :- http://msdn.microsoft.com/en-us/library/ms174378.aspx
----------
Ashish
February 9, 2011 at 8:37 am
Viewing 15 posts - 331 through 345 (of 812 total)