In the one or two places I've been that have had backup exec (or similar) the SQL Agent has been put in place and configured by none dbas who have...

not entirely sure what backup exec is capable of, would not be surprised if it cannot do differentials.

One thing I am sure of, there is no way it does a...

SA (3/25/2009)

---

One way would be to move all the data to one file remove all the empty data files. Add the new files to the database with the sizes you...

This is just like buses, nothing for a month, then 3 at once:-)

Stamey (3/25/2009)

---

Here are a couple of possibilities.

1. Set up DB mirroring from primary to DR server. If there...

of course thinking about this....

SQL fills depending on amount of free space in an effort to fill the files at about the same time (see BOL on this). So having...

these are all in the same filegroup right?

decide what size you want them to be...........

dbcc shrinkfile(name,sizeyouwant) the ones that are larger

alter database...modify file the ones you want to make larger

do...

thanks for replying guys!

Mr(?) Noob, your way certainly gets round the upgrade problem.

Trouble is I am greedy and was really hoping to leverage SRDF to keep the failover in synch...

Noel, we are on different wavelengths. see this post bottom of page 2 (for me)

rishgup (3/24/2009)

--------------------------------------------------------------------------------

I ran sp_help_revlogin on Primary server and copy script and run onto Secondary server.

It gives...

noeld (3/24/2009)

---

IF and only IF there is only one database you can drop all SQL logins on the destination Server and copy the logins from the Primary using sp_help_revlogin. Then...

noeld (3/24/2009)

---

No sp_help_revlogin is useful for Transferring logins NOT to remap them! Which is what the...

it was backed up on a different server so is not recorded in msdb so will not show up. select the restore from a device option and browse to the...

its a different domain (according to your previous posts) and a different server name I guess, thats probably why windows groups or users do not exist. this is what the...

rishgup (3/24/2009)

---

I ran sp_help_revlogin on Primary server and copy script and run onto Secondary server.

It gives error that SPID is in use. and when I change query from Create login...

then sp_help_revlogin will solve your problem!

if you use sp_help_revlogin then will never be necessary to run sp_change_users_login.

If the two servers are in different domains or you use local windows accounts, you will need to fix...