Thank you

2005 sql server version

Thank you

So for the system db and user db it is the same order right?

Optimization,Integrity,Full back up one maintance plan for system and the same plan for user db right?

Transaction logs...

Thank you

We are on Microsoft SQL Server Standard Edition (64-bit).Thank you

Sorry to ask you a stupid question, how do I know if I am running on enterprise?Thank you

We always have people in the system,but I think would do on evening hours when less traffic. Thank you

Steve, just to understand, varchar takes space a little with null values and without null values, right?

Thank you for advise, but could you be more specific of the steps:

1. full backup, move that, restore it.

2.Do a differential backup, move that , restore it.

3.Do log backups

and what's...

So from reading all the comments, as far as I understand, varchar doesn't reserve space.

The varchar takes storage space, but is not taking storage space if varchar is null...

I need to copy everything from the servers. We are moving it to another place.

Thank you

Thank you for your help.My concerns are: I was told that Basically, many columns within select tables are allowing NULL values (as a default). No values are entered and...

This is what I was told:

Basically, many columns within select tables are allowing NULL values (as a default). No values are entered and because the data types are varchar(X),...