Viewing 15 posts - 1 through 15 (of 110 total)
Something that just crossed my mind... What login is used for the sql server service account on the source server?? After restoring master to destination maybe it is failing because...
October 12, 2006 at 3:08 am
Restore master to secondary with move.
This needs to be done by setting -m flag in startup parameters (via em under general). restore can then be performed via sql em or...
October 10, 2006 at 3:57 am
Setup an AT schedule or use windows scheduler to schedule a job external to sql server that checks for presence of sql server service process.
October 9, 2006 at 10:43 pm
Would seem as though msdb and model databases do not exist or at least not where master thinks they should be. Have you restored these two databases after master has...
October 9, 2006 at 10:41 pm
Not sure what the package is doing, more info may help.
Note by default xp_cmdshell is disabled if you are calling this it will fail, other causes maybe the login...
October 9, 2006 at 10:25 pm
Or from Management Studio you could use the export wizard to export only the table and its assoc indexes etc. to the target DB.
July 23, 2006 at 7:41 pm
Hi all, I had a similar problem recently after I performed a rename of the server, newly created jobs were ok, all old jobs wouldn't let me modify or delete...
July 12, 2006 at 9:48 pm
Not quite sure what you mean when you say one file on emc and one file on regular disk works but then you say one file on regular disk and...
July 5, 2006 at 7:07 pm
I have done this many times on same server without an issue. More info on what errors you are encountering may help .
July 4, 2006 at 1:11 am
Or you could use a tool that I have found fantastic. SQL backup2000 provides a nice GUI interface and is very handy for copying large numbers of packages. I think...
July 3, 2006 at 4:21 am
Hi, not sure what you mean vendor has advised?? If you use normal SQL Server backup of a database on a sql cluster this backup can be restored anywhere (SQL...
June 30, 2006 at 1:23 am
In order for the sp1 apply for reporting services the db engine must be started to allow authentication. SSRS seems to be the only product in the SP1 to complain...
June 8, 2006 at 1:09 am
Try the following if the login you are using is not a local admin:
Windows 2003 Server (SP1) and Windows XP (SP2)
- If the user running under non-admin account it needs...
May 24, 2006 at 1:43 am
Uh, I think this thread has gone off the topic which was to allow the changing of the proxy account.
April 28, 2006 at 2:48 am
Thats correct, all totally normal behaviour. If you schedule the job then all should work correctly.
April 28, 2006 at 2:10 am
Viewing 15 posts - 1 through 15 (of 110 total)