No i didn't mean that way 🙂

The question just came in my mind was, if a user can do other limited operations (can see the DBs by Ent Manager) but...

Is there any way to deny all TSQLs on sql server for a particular user or for all.

Sorry earlier I missed it, striped backup is useful to split backup file size in multiple files so that it can be easily transferable OR if you are facing disk...

Sorry to interrupt you in between, i have never used striped backup but wanted to explore it. Today i have tried to take striped backup for my test database(named working)...

Of couse this is not a good practive to take backup on DVDs, i just wanted to explore the stiped backup utility provided by MS.

Hi,

I have tried striped backup for my test database with::

backup database [mytest] to disk=N'C:\dbaScripts_1.bak',

disk=N'd:\dbaScripts_2.bak'

and tried to restore with below script::

RESTORE DATABASE [mytest] FROM

DISK='C:\dbaScripts_1.bak',

DISK='d:\dbaScripts_2.bak'

WITH MOVE 'mytest' TO 'D:\Program Files\Microsoft SQL...

Have any body used striped backup, or what Mohan specified is called striped backup?

BJ is right, you can easily test this environment on Virtual Setup. You can create 2 or 3 virtual servers (depending the configuration or your machine/server) and easily test...

I think striped backup would be a more practical approach instead of zipping etc. zipping them and copy it to DVD is fine, but you could have a problem while...

Gail, this makes sense to me. Thank you very much for the explanation, much appriciated.

Gail, thanks for you concern.

As per my knowledge, The model database is a template, used by Microsoft SQL Server when creating other databases, such as tempdb or user databases. When...

Exactely agree with you Gail.

We used to do intigrity check every day for the system database exludeing model&tempdb and weekly optimization for system database. for user dbs it depends of various things.

Thanks Gail for this information.

Gail , MANU this scirpt doesn't work for sql 2000

select d.name as DatabaseName, mf.name

as FileLogicalName, mf.physical_name, type_desc, max_size

from sys.master_files mf

inner join sys.databases d...

Yes you are right Gail, the bug is for log file only.

Thanks MANU its working fine.