ARe you able it accessible it from QA. Try refreshing or stopping and restarting SQL Server.

--Kishore

Then you can use varchar datatype. However, in Yukon you have 3 new datatypes : varchar(max), nvarchar(max) ans varbinary(max) where you can store upto 2GB of data.

--Kishore

Use (mydb)

select * from sysfiles

This will give you the full path where your .mdf and .ldf files are located.

--Kishore

1. Try to check if there is enough space available on the drive where your data files are located (.mdf and .ldf files). It might be that the space is...

I think there is some problem with IE itself. Is that the only database, you are facing problem with or any other database. If you are getting for all databases,...

You may evern want to try out SQL Backtrack for SQL Server from BMC. It also has a compression utility available. http://www.bmc.com

I dont see any problems running T-log backups every 15 minutes and that too for such  a small size. You could use SQL Profiler to see wht kind of statements...

Try backing some Windows files on the tape drive.

GO to Start -->Programs --->Accessories--->Backup. Try backing some txt file on Tape using this utility. If this works, then sql server backup...

Well, that is my last resort. But actually I need a sql script which will contain all the structure and data for the database. Any further ideas ?

--Kishore

Having a WITH (NOLOCK) to every SELECT statement is not a good idea and that to for every select statement.

I have billing related applications  where every transaction depends upon...

Thanks for the replies. Highly appreciated.

--Kishore

You can run select @@version in your QA. This will tell you what version of SQL server are you using.

--Kishore

You can always schedule it to run at different intervals. However, since your database size is not very large, it must be happening in few minutes.

Once the database size grows,...

There is no need at all. But why do you have to restart your server everyday ? However, there is no need to have a full backup after the server restart.

--Kishore

No Doubt. Maintainence Plan is the best option to take backups, schedule them and delete the older ones.

I am not sure what kind of env, you have. But if...