SSIS and workstation components are not cluster aware.

This is what I did in 3 different situations.

Even though I chose Database Engine, SSIS and SSMS components to get installed on the...

What you can do is right click on the package --> Export Package --> Package Location --> File System --> Package path.

Then open the saved file from VS.

Hope this helps

Hi guys,

I have a question about Veritas. We're using 9.1 Revision 4691 in our environment to backup just the disk to disk backup files from native SQL. We're telling the...

I deleted the registration, and re-registered it, still nothing.

Version = 8.00.760

Thank you Brian

You can also use this:

alter database db_name modify file (Name = old_data_name, NewName = New_Data_Name)

alter database db_name modify file (Name = old_log_name, NewName = New_Log_Name)

Hope this helps

Hi folks,

looking for a UDF that will parse a string, and address field in particular.

say you have '123 any street'. I need each component separated.

Any feedback or thoughts will be...

well, in the maintenance plan, I'm already specifying to retain the files for 7 days. And I don't wanna have 3 month supply of nightly backups. Don't wanna have 90+...

thank you Lynn

I would drop the media set name re-create another backup job, and try to restore from the new backup

got it to work, thanks for all your help

this is what I get when I print it and execute it

BACKUP DATABASE Joe_LeninL

TO DISK = 'K:\User_Databases\CFT_dbs\Data\Joe_LeninL\Joe_LeninL.bak'

WITH INIT,

NOUNLOAD,

NAME = Joe_LeninL backup,

NOSKIP ,

STATS = 10,

NOFORMAT

Server: Msg...

thanks for the response, when I print the statement to screen, it shows the code, but when I run the EXEC (@ExecSQL), I get this

Server: Msg 170, Level 15, State...

I don't understand. Plz explain

thx

Jeff,

what if there are some prefixes and suffixes in the column? I'm facing this dilemma right now. What would I add to your script to successfully parse prefix, first, middle, last, suffix?

Any...