index..

i think his backup set up is 'append to media'

and with this he wants to separate each back ups as a single file..

>>

i dont think there's a posible way for...

or simple set the duration like: duration > 9999

hope this will help;

http://sqlservercodebook.blogspot.com/2008/03/sql-string-functions-tutorial.html

Astig!!:D (great in english..;p)

lots of thanks gianluca.. now im learning..;p

i should have mention it.. but i work with MS SQL 2000..;p

thanks for reply gianluca

actualy i'm 3 more exam away from MCDBA.. and MS SQL 2000 is going to resign by 2009, if i'm not mistaken..

i'm from philippines, and from my point of view,...

GREAT!!!..;p

thanks..

but on my side it give -1 days..

i've try to runn it on my local machine and the result is:

SQL Server “LOCAL” Uptime: -1 days, 25 hours & 1 minutes

i...

hi,

my problem is this script work fine;

select *

from openquery(MY_LINKEDSVR,'set fmtonly off;exec master.dbo.xp_fixeddrives')

go

but this script return the no column error;

select *

from openquery(MY_LINKEDSVR,'set fmtonly off;exec master.dbo.sp_helpdb')

go

error msg:

Server: Msg 7357, Level 16,...

i mean i installed a new instance of sql server in a new machine (sql 7)

and my msdb backup is from different sql server instance?

Hi All,

is it possible to restore msdb only?

lets say i modify some jobs and i want to recover it, do i need to restore only the msdb? or i still...

additional question..

how can i migtrate or upgrade my DTS Packages?

sorry but i dont think the sql 2005 or 2008 is an option..

some application might not work.. unless developers are willing to modify the aplication..;p

byt, how will i upgrade my...

Hi thanks for the concerns.. but i made it work..;p

i have this ms sql 2000 RTM on win 2003 server, found that sql server is not listening on tcp so...

thanks..

btw it is a backup file not a device nor anything..

like backup to drive c:\databasebackup.bak blah blah NOFORMAT

anyway.. i guess my only option is to delete the said backup file...