Viewing 15 posts - 61 through 75 (of 135 total)
Thanks All,
I got the point , that I should keep the schedule as
On in weekend night Full backup
daily At night deff. backup
And depending on data loss Accepted, log backup(In minuts).
Ali
MCTS SQL Server2k8
November 12, 2010 at 11:32 pm
Thaks
muthukkumaran 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
Ali
MCTS SQL Server2k8
November 11, 2010 at 12:53 am
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) but, He...
Ali
MCTS SQL Server2k8
November 11, 2010 at 12:12 am
Hi
Say Hey Kid
Actualy It was typing mistake
I meen 'One Terebite Plus Database,
Thanks
Ali
MCTS SQL Server2k8
November 11, 2010 at 12:06 am
Hi
No, not than one witness in Database miraring. As per my expe.
Thanks
Ali
MCTS SQL Server2k8
November 3, 2010 at 2:43 am
Hi
Thank You Lowell;
for quick response. I got the Clear Answer which is'NOT' thanks!
Ali
MCTS SQL Server2k8
October 16, 2010 at 3:53 am
george sibbald (10/5/2010)
GilaMonster (10/5/2010)
george sibbald (10/4/2010)
Error 112 in the error logYou know, it's sad when we know OS error codes off by heart....
I resemble that remark.........
Hi
I think there is...
Ali
MCTS SQL Server2k8
October 6, 2010 at 3:23 am
amit-1143912 (10/1/2010)
I have applied inner joins on tables to which 35...
Ali
MCTS SQL Server2k8
October 5, 2010 at 5:47 am
forco02 (10/5/2010)
Ali
MCTS SQL Server2k8
October 5, 2010 at 5:34 am
We normally do a full backup every night, and a transaction log backup every 15 minutes, 24x7.
Hi
marc, in my openion, just falow Michael Valentine Jones's comment
Ali
MCTS SQL Server2k8
October 5, 2010 at 12:33 am
Hi
Is it a SSIS package schedule. If so check the step next to MSDBLog backup.
Ali
MCTS SQL Server2k8
October 5, 2010 at 12:13 am
Krasavita (10/4/2010)
How to delete database? Thank you
hi
Krasavita
Krasavita, Just I want to what is in your mind, are you really want to delete the Database?
Just Fallow the Gail Shaw comment,...
Ali
MCTS SQL Server2k8
October 5, 2010 at 12:05 am
Geoff A (10/4/2010)
Select * from [linkerservername].[dbname].[dbo].[MyTable]
Geoff's above query should work.
Ali
MCTS SQL Server2k8
October 4, 2010 at 11:30 pm
Hi
Can you post your's wretten query. You can also use Export wizard.
Ali
MCTS SQL Server2k8
October 4, 2010 at 11:27 pm
hi
Paul,
this link may use full for you:
http://msdn.microsoft.com/en-us/library/ms143506.aspx#SE32
Ali
MCTS SQL Server2k8
October 1, 2010 at 6:27 am
Viewing 15 posts - 61 through 75 (of 135 total)