Viewing 15 posts - 526 through 540 (of 859 total)
mohammed moinudheen (11/15/2010)
If the log file gets corrupted, is it possible to rectify the corruption andrestore the database to point in time.
Please share your inputs.
Yep,
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
http://www.sqlskills.com/pastConferences.asp
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 15, 2010 at 1:27 am
hemadribabu (11/12/2010)
Yes daily its 1 time purpose
If its one table , Then write a script and automate it.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 12, 2010 at 5:12 am
rmatthias001 (11/10/2010)
Can somebody tell me what the grading scale and passing score on this test is?
Yes its 700.Two weeks back i had that exam.
i got 1000:-)
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 12, 2010 at 4:26 am
hemadribabu (11/12/2010)
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 12, 2010 at 1:57 am
Roust_m (11/11/2010)
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 12, 2010 at 1:11 am
MostInterestingMan (11/11/2010)
Thanks for all of your inputs...RESTORE DATABASE mydatabase
FROM DISK = @Backup
WITH REPLACE, RECOVERY
fixed the issue. Again thanks.
Thats already suggested by gail.
Huh? That's not even valid syntax.
--------------------------------------------------------------------------------
Gail Shaw
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 12, 2010 at 12:05 am
hemadribabu (11/11/2010)
sql 2005
I have to take a Backup of a table from prod instance and restore the same in Reporting instance.
this process should be automated, kindly tell me...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 11, 2010 at 11:59 pm
MostInterestingMan (11/11/2010)
GilaMonster (11/11/2010)
MostInterestingMan (11/11/2010)
I have a database stuck in 'restoring' but there is no restore progress in the sql logs. Should I just let it continue?
Was this DB restored...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 11, 2010 at 7:17 am
Did you add sql server account to Lock Pages in Memory ?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 11, 2010 at 2:58 am
c.ajitkumar (11/11/2010)
when i executed ur query i got the same value for total memory and target memory...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 11, 2010 at 2:54 am
saidapur_satish (11/11/2010)
1+TB data means not a jock..........
If you give the full backup means take too much time & also that time your server is...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 11, 2010 at 2:47 am
c.ajitkumar (11/11/2010)
thanks for replying
in my scenario i have 64 GB of RAM and i set the min memory =1GB and max Memory 45 GB
but when server is busy...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 11, 2010 at 1:53 am
Ali Tailor (11/11/2010)
Thaksmuthukkumaran for responce,
May I keep
One Full Backup Weekly at Weekend Night
One Defferential Daily at Night
And Trans.LogBackup On Every one Hrs.
is it OK?
thanks
The answer is "It depends"
Its...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 11, 2010 at 1:05 am
Also i have recommended to read the Kimberly's(KT) link
Instant Initialization - What, Why and How?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 11, 2010 at 12:42 am
Ali Tailor (11/11/2010)
Vishal.Gajjar (11/11/2010)
TB = TeraByte??You can perform Full Backup Once a Week, Preferably on Weekends,
and a Transaction Log Backup Every Hour ....,,
Thanks Vihsal,
I Answered the Same (Above in quote)...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
November 11, 2010 at 12:37 am
Viewing 15 posts - 526 through 540 (of 859 total)