If you backup a database that has 4GB of data and 4GB of space, you will still require 8GB free to restore this database.

As far as I know you cannot change...

From BOL:

ANSI_PADDING

When set to ON, trailing blanks in character values inserted into varchar columns and trailing zeros in binary values inserted into varbinary columns are not trimmed. Values are...

Raj,

When you install SQL Server you can choose to install the SQL Performance Counters.  They are included by default.

I have seen the counters 'disappear' on a machine running Windows 2003. ...

Yanick,

Could you please explain what RDL means?  Maybe that is why you haven't had any replies yet.

Thanks,

Angela

Marc,

You can do native SQL Server backups to disk while users are in your database, so this shouldn't affect you need to have 24/7 availability (it will just run a...

Johan,

Have a look at running sp_who or sp_who2 in Query Analyzer.  It will show you the databases users are connected to. 

Each unique SPID is a user...

Hans,

AFAIK (and I may be wrong),  Simple Recovery will minimise the amount of logging that occurs, but will still log something.  It needs to log some transactions so that if a...

Are you able to run the job associated with the maintenance plan manually?

I would delete the maintenence plan and recreate it.  Then go from there.

Cheers,

Angela

Shahgols,

I think you can only restore your full backup.  Backing up the log now will not work as you are missing all the transactions that occured between the 4/16/2004 and...

Hi Marc,

You will need to confirm with your vendor what specific mode they want SQL Server put in.  Generally, for snapshot backups you either have to take a database offline,...

Jeff,

You don't need to mark your post as resolved.  At the end of the thread its polite to describe how you solved your problem and thank anyone that provided help. ...

Gary,

AFAIK and I may be wrong on this, but you cannot rename the logical filename of a .mdf, .ndf or .ldf file while restoring a database.  The example you have...

Okay what about this:

-- First we get the all the records and any duplicates are given an id to tie them to the first record found with a matching lname,...

Chetan,

Just restore your database as normal.  Then use:

ALTER DATABASE yourdatabasename

MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name)

To change the logical filename for .mdf, .ndf, .ldf to whatever you want it...

Can you please post exactly what you are typing that doesn't appear to be working?  Where are you trying to run the sp from?

Thanks,

Angela