You can write a automated script to query sysdatabases table, pick up all the databases and backup those everyday. You could schedule it using SQL Server jobs to run on...

wow...this is amazing..... never was aware of this before....thanks guys ...

Thank you very much.

Thanks Chris. Please suggest some similar script for varbinary too. Thanks for the help.

--Kishore

I dont know what size database you are running. If its a medium sized database, I could think of Full Backups been running once in a day.

Differential backup running at 6...

You can alter the table filegroup using SQL EM. Go in Table Design and right click for Properties. There you have a option to change the filegroup for that table....

Are all 3 of your databases still on the server. If any one is also no there, then it will fail since it wont find the database to backup it...

There seems to be some problem with your network share. If you get a different network share for the backups, it should be working fine.

--Kishore

Thats right Martin. To rebuild you need to first copy the \Data folder, remove the read-only atttribute from all the files and folder and then run the rebuildm.exe from the \Data...

Where are you taking backups ? Is it on a local or remote machine ?

--Kishore

Why do you want to combine your SQL backups with system files ?

1. What is the size of your database ? 2. Is it a 24*7 enviornment ? 3. What...

SQL Server 2k allows hot backups. You need not put your SQL Server in single user mode to take the backups. SQL Server will perform the backups and also serve...

I feel 1000 connections is too much. I have a HRS system running in my enviornment (24*7) with around 100+ users accessing the database but using different applications. I have around...

Well it all depends on how your enviornment is setup, what hardware configuration you have, what RAID levels you are using, what kind of indexes have you defined on your...

If you want to give read only permissions to the users in the database, you can give only one permission.

exec sp_addrolemember 'db_datareader','rtest'

 go

Follow these steps : First create a login...