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: )

685 reads

Blogs

Adding Git LFS Support – #SQLNewBlogger

By

I got this message recently while committing some changes: This post shows my work...

EightKB 2024

By

EightKB is back! The biggest online SQL Server internals conference is back in 2024…it’s...

T Sql Tuesday 170: Learning From Abandoned Projects

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Read the latest Blogs

Forums

How to install these components?

By webrunner

Hello experts, I got a request to install the following components on an application...

Sudden Performance Drop Off for Data Import

By Eggz

This is my very first post to one of these types of places so...

Not able to connect on analysis services on azure

By astrid 69000

Hello, I am trying to migrate a tabular model from onprem to azure analysis...

Visit the forum

Question of the Day

A New Audit

I have a brand new D: drive on my system that is formatted, but contains no files or folders. What happens when I execute this code?

CREATE SERVER AUDIT audit2 TO FILE ( FILEPATH ='D:\audit' );
GO

See possible answers