Technical Article

BCP OUT all table data in your Database

Data Recovery is vital. This script will cursor through your database and BCP OUT the table data to a directory specifically for each day of the week (in numbers - where 1 = Sunday and 7 = Saturday) in order to have table recoverability up to 7 days. The first step is to create the […]

You rated this post out of 5. Change rating

2006-05-11 (first published: )

684 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

How to Setup Backups and Restore planning in SQL Server Availability Groups?

By BK

I need some help regarding How to Setup Backups and Restore planning in SQL...

Partition Large Tables needed

By sqlguy80

Hello Gurus, I have  a requirement and need to implement the solution quickly. SQL...

Deleting the Standby file

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deleting the Standby file

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers