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"
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.
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...
January 7, 2010 at 6:26 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...
January 4, 2010 at 5:14 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
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.
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...
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...
January 4, 2010 at 9:19 am
To add to earlier replies, have you checked if Windows has rebooted at that time?
January 4, 2010 at 9:12 am
Looks like that you are running short of Memory on that machine.
January 4, 2010 at 9:08 am
GregFrazer (1/3/2010)
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...
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...
January 3, 2010 at 9:07 pm
Viewing 15 posts - 361 through 375 (of 1,292 total)