How big is your database backup file size ? I have a 600 MB backup size running twice a day on a network share from last 3 years with no...

Hi,

As far as i know, it was not possible in sql 6.5 to get a object from a full backup file and the same continues in all versions of sql...

Thanks guys for all the help.

This article is excellent. I agree with wht Steve said.

Infact the life of a DBA is more hectic as he is dealing with data and data is the core of...

There are 4 types of transaction isolation levels. Here is the syntax :

SET TRANSACTION ISOLATION LEVEL

    { READ COMMITTED

        | READ UNCOMMITTED

        | REPEATABLE READ

        | SERIALIZABLE

    }

Once you set...

You could modify your SQL Backup Maintainence Plan to delete the file.

I mean if you are taking a backup at 10:00 am, you could ask the plan to delete the file...

The information provided by Scott is ultimate. I myself had my database running on a network drive for quite some time, and it affects performance and the risk of keeping...

Hidden shares should not make a difference. Try unhiding the share and taking a backup. If it works fine, then, unhide and take a backup.

I have my SQL Server backups...

What is the recovery model you are using ? You might consider to change your recovery model to either Simple or Bulk-Logged if you do not really need Full Recovery...

Check to see if your transaction log is full and it has enough disk space to accomadate the changes.

--Kishore

What exactly are you looking at ? Are you trying to setup replication and log shipping on the same machines for the same databases ? Is so, why do you...

You cannot have a write mode of a Secondary Server in Log Shipping. You can either have a read only mode or standby mode for Secondary server.

If you need to...

What is your database size ? Is it a 24*7 application ? What is the frequency of the backups you are currently taking ? What time in the day is...

You will get the maximum information in these 2 tables.

select * from sysdatabases

select * from sysaltfiles

--Kishore

You may connect using QA and change the default database for the login using sp_defaultdb.

EXEC sp_defaultdb 'login', 'database'

--Kishore