It is said this will work for .BAK files...can this be used for .dmp files as well and can anyone help me with that...i have 200 db's to migrate to...

I ahve looked around a lot and yet to find the process to change table owner. Can someone pls show with an example. like in sql 2000 i used sp_changeobjectowner...

Any idea for the same error with SQL 2005?

We do need check the backup's on a daily basis as its the back bone for dba's. We get caught in tight spot only when there are no backup's when...

R u backing these to local disk or external storage device. If external check for permissions...just a guess

check the FileDSN settings on the 2 computers u have issues with..i mean the FileDSN's that were created to access SQL Server.

Its is always advisable to leave the fill factor at default value unless u want to use it. Fill factor affects the fragmentation of index pages if its wrongly calculated....

Its always a good practice to create another admin account with same 'SA' permissions and use that instead of SA. As far as the attacks to hack in...its not impossible...

Thanks for all your inputs, but we still have the same issue and error. The userid used to connect is the same for all the db's. The 2 db's in...

Same here. Especially with CLR out with sql 2005 its required to control the changes. Are there another options apart from using a source control tool??

Pls share the query that gives the output for marked trans log.

We have a similar enviroment here. What we did was this:

- Backup all the db's pointing the path to new server drive.

- If the directories are different from the old...

Just to brief on truncate: it only free's up space on the log but the file sixe will be the same unless u shrink the log.

U can run backup and...

As said in BOL:

USE UserDBGODBCC SHRINKFILE (DataFil1, 7)GO

"Datafill" is the logical file name and u need to difine a size the file needs to be shrinked to. Try with...

We recently migrated from SQL 7 to SQL 2000. In SQL 7 whenever a clustered index was rebuilt the NC would get rebuilt, but in SQL 2000 i do not...