so how can we set that format of date through EM and through QA(not for the active connection only but for all) so that this Point in time will work...
so does that mean that i cant restore the Point in time recovery through EM??
Hi Firstly Thanks a lot for you all for the valuable suggestions I wanna Track What Each user Did on that Day i mean as a DBA I wanna Keep Track...
Hi How i can See All the Statements and USers Associated with the statements every night? which is run on a particular Day ? I use profiler whole...
no, i m trying through Enterprise Manager only..... and in the above stated scenario, it successfully restore the full backup and first transaction...
The sequence of RESTORE LOG is 1) Full Backup restoration 2) 2 Log Files restoration whose timings are (6:50am and 6:55am) and i am trying to...
Hi all, I am trying to do a point in time recovery on a SQL Server 2000 DB but am running into some issues. (Through Enterprise manager) I can...
So You say if i have one Publishe and one subscriber and there is nothing updated on the subcriber do u suggest a one way merge replication...
Hi We have one production site and we want to replicate that data to another database server. one of our DBA is suggesting for merge replication as...
I am Facing a problem in my database server with slow perofrmance i have a Databse server with Sql200 enterprise edition these are the...
Hi there, i have stuck in a strange prblem in visual basic n sql. I am able to doinserts and update in a table thru visual basic. Now when i...
can any on etell me how i can download database hammer or any toll by which i can test my database with number of users ??? thaanks a lott
hii i have a database server whch right now takes hits from 50 users . now we are moving that db into a envirnoment where users will be min 500 and...
Strangely the server in shich it runs faster have a small web server also on that and still its faster and hardware configuration is concerned its...
"because the statements are in built in the application and it is running fine in other locations" I mean we have the same setup in out another...
hi satya thanx but i cant actually modify the queries if some prblem persist because the statements are in built in the application and it is...
Hi i am running sql2000 on win nt 4.0 i have database which is 9.5 gb in size which is geographically located in defferent location and user...
Hi i am tryin g to replicate a database its working fine but the problem is the identity columns are replicated but not the properties like primary...
Hiii My transaction log sized to a 6 gb size and the DB was in full recovery model .what i done is i changed the recovery model to simple and...
hi we have 10 databases in one instance and we had taken the backups of all databases including master database . but during restoration to...
Separate names with a comma.