Do you have security access to Bol?

I know it's used to select into tables, copy all the data, and thus a backup.

But books online might be able to give you...

no easy fix eh :/

Well I'd sit and wait for it to happen, then grab the xact_seqno and browse it.

I bet ya it will give a clue.

if...

Don't underestimate the power of Bol

Type backup, highlight it and press shift F1

It gives a really nice description on the parameters, those you asked for and some you may want...

select * into <table>_Backup from <table>

where table is your table

Hi

In order for you to restore that filegroup the primary filegroup needs to exist, in this case it contains all the other 100 tables 🙂

So you have create a table...

The best tool,

is a good DBA.

However, 90% of the perfmon counters are the same across those systems.

I suggest you log the trace output and alert on them.

The benefit it's the...

Hi

One thing you need to check here,

Make sure your tempdb is on the default 8mb growth.

Then add the sort in tempdb and maxdop to your index build.

If you have no...

Hi

Just to get some things straight,

You say the compressed backup is 2TB, you keep a months worth of DB's ? 30x2TB

And once you are in the new month you keep...

You shouldn't be running this low on any drive, not even it's "just" your backup.

What if something crache, you get you DB partially online and need to restore the backup...

Hi

The snapshot will lock your tables to make sure that the schema is collected for the subscriber is 100%.

Very simplistic terms.

Thus try and not run snapshots on large active tables.

Cheers

Jannie

Hi Vividus

When you schedule the package in the agent. Make sure you specify run as 32bit.

It usually solves most driver related issues. The GUI is 32bit and hence if you...

Hi

Don't forget the handy xp_regwrite

I do not think it's always the best to due it this way.

Cheers

Jannie

Hi

Afaik I know the MGMT studio is sluggish on x64 as it's 32 bit.

This might have the same issue for your machine.

Also if you are on the server it will...

Hi

What I have done in order to keep multiple backups is you take you datepart (day) when you build the backup string.

As below

name = convert(nvarchar(8),getdate(),112) + '_' + convert(varchar(2),datepart(day,getdate() %...

Hi

Checkout the sp_helpjob & sp_helpjobstep.

They are system functions, and you can use them with job name or id.

Cheers

Jannie