dosskavi (2/22/2010)

---

I'm trying to copy the database. I'm using the copy database from the task manager. If fails for the following reason.

description=Executing the query "CREATE USER [winadmin] FOR LOGIN [test\winadmin]...

Scott Pettman (9/27/2009)

---

I have recently migrated a db from SQL 2005 to SQL2008. An application needs to access that database from the original server but the linked server object...

Ulysses Brown (2/22/2010)

---

So I thought that using the Microsoft OLE DB Provider for SQL Server (SQLOLEDB) would make a difference. It did not. As a matter of fact,...

A1Vijay (2/22/2010)

---

If I bring SQL offline, dont I need to bring it online to detach the DBs? In that case, I establish new connections before I can run the detach...

AndrewSQLDBA (2/22/2010)

---

I never use a third party tool when working with SQL Server, it can just about anything, and it can sure handle copying a file across the network to...

First thing your server team should have disabled pointer (or whatever) once your backend database server went down, that should be automatic. I have no idea how this application works,...

Assuming standalone install, if it is cluster install let me know few more additional steps straight forward. Most of them had already mentioned how to do migration and check list...

Is that required to upgrade SQL 2000 first to SQL Server 2005 and then to SQL Server 2008?

Can't we do the migration directly from sql 2000 to sql 2008?

If not,...

I know you have got the answers for questions already, Are doing this install on cluster? Or Stand alone? Sorry i did not read all the replies 🙂

EnjoY!

This may be due to the database owner was windows domain account and login deleted later, or if you restores database from another server which doesn't have the login account...

jpSQLDude (2/22/2010)

---

GT-897544 (2/22/2010)

---

I assume it is SQL 2008 is that correct ? What is the compression ratio of backup files with Robocopy? Once you answer these questions i can recommend...

jpSQLDude (2/20/2010)

---

I have many servers I have to back up.

I am using Maintenance Plans to create files, but then I use batch files and Scheduled tasks to drive 7-Zip and...

Did you copy these databases from other servers? Do you see Null word as DB owner or just blank?

Any users complaining about authentication failure? No matter what the criticality of the error you should fix...

quick question :

if i don see any log for few hrs on sq server does it mean that server was rebooted during that time ? how would i find if...