Viewing 15 posts - 361 through 375 (of 1,292 total)
Pradyothana Shastry (1/7/2010)
In Bulk recovery model can we take log backups?
A straight answer is "Yes"
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 7, 2010 at 9:14 am
ramyours2003 (1/7/2010)
how can we take strip backup ?
Strip backup or Striped backup?
Look at this if you are looking for striped backups.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 7, 2010 at 9:11 am
I second Lutz thoughts, you can use any one of the ideas. I personally would incline towards SSIS since it gives more capabilities and tools to do this, considering a...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 7, 2010 at 6:26 am
praveen640 (1/5/2010)
i am using sql server 2005 windows xp . I have to restore and backup all of my data from...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 6, 2010 at 6:35 am
You seem to mixing up the terminology again.
There is SQL Server Error Logs and Windows Event Log and what is that you are interested in viewing? If it is SQL...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 5:14 pm
Right I agree !
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 12:06 pm
The question seems to be a wrong one. You don't shrink SQL Server log file, you recycle it. You shrink a Database transaction log File.
Use
EXEC sp_cycle_errorlog
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 11:55 am
Have the SQL Agent write information message into a text file and you should be able to see the output of the execution in that file.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 11:35 am
CirquedeSQLeil (1/4/2010)
The holidays were great. And adding to the long list already - I hope everybody else enjoyed their holiday season.
I had a fantastic time during the holidays. Hope...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 10:24 am
Have you tried changing the script to filter out the model database
Try adding and name ! = 'Model'
If this works, then you can try backing up Model only...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 9:19 am
To add to earlier replies, have you checked if Windows has rebooted at that time?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 9:12 am
Looks like that you are running short of Memory on that machine.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 9:08 am
GregFrazer (1/3/2010)
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 3, 2010 at 9:38 pm
Have you tried searching online?
If you have started reading a SQL DBA books you should find these in them too.
Any way in short and this is not a complete...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 3, 2010 at 9:30 pm
sarithanr82 (1/3/2010)
I heard that for transactional replication to be working the connection can never be down.
Not sure this is completely true.
Any ideas about Merge replication??
It is more...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 3, 2010 at 9:07 pm
Viewing 15 posts - 361 through 375 (of 1,292 total)