I have MSDB set to "simple" and take a full backup daily.

PearlJammer1 (9/30/2013)

---

After a bit more digging around i did come across from Dave Pinal. Looks like what i need to do i think but i can choose to script the...

could you do "truncate table" instead of delete ? Should be faster, and no logging since you don't care about data recovery.

Woukln't it be easier to generate object scripts from an existing database, then run those scripts in the new database ? That would build empty tables. Add what...

Also, "query help" suggests that you have worked on it, but are stuck.

What have you got so far ?

That's odd. Maybe a another job outside of SQL such as a network backup is running t-log backups ??

fwiw. I backup MSDB daily.

I never make changes through the GUI. I go through a few steps when modifying data on the fly through a query window.

1) SELECT the data to be changed to...

That is what I...

1 method would be to create a separate job for Proc2, 3 and 4. Then Proc1 could run sp_start_job "proc2' etc...

Thank you very much.

So the DNS entry will make all connections that normally point to Server_A, now point to Server_B ? And as long as the expected databases & permissions...

Can a default SQL instance be renamed ??

I forgot about the DNS alias. I think that was done at a place I worked at a long time ago. Where...

Perhaps I can run these steps after renaming the server itself to rename the SQL instance ??

sp_dropserver 'Server_B'

GO

sp_addserver 'Server_A', local

GO

From Server_B, I am not able to pull from Server_A. But if I log on Server_A, I can push to server_B ..... hmmmm

Well, that's good enough to get what I...

I had not go to the point of running it as a job, just running in a query window, or as DOS command. Does it matter if they are...