You need to have them in different plans because they have to run at different intervals. Remember what the point...

No. I mean the import/export wizard

From object explorer in management studio, right click a database, select tasks, select Import Data

You can't backup the log of a database in simple recovery mode. The point of simple is that the log is not retained and backups of it are not required.

What's your reason for clustering? What are you trying to gain?

It doesn't make any difference what the server's service accounts are. As long as you're connecting with an account (windows or sql) that has login rights on the other server.

Windows...

You don't, directly. First open it in a text editor and remove everything but the file names. Once you're got the file cleaned up, you can use the import/export wizard...

There should be a file called dirinfo.txt in whatever directory you ran that from, not in the snap directory.

Means that either the server isn't running, you've mistyped the name, or there's a firewall or similar preventing connections.

Can you ping the second server from there?

marg131 (10/27/2008)

---

thanks for asking, I am kind of new here. yes, model.mdf and model.ldf are still under data folder of sql 2000. One thing I don't understand is I did...

DIR "E:\Visual Studio Solution\Web Application\Template\Snaps" > dirinfo.txt

If you're already deleted the encrypted content, then there's no point in getting the keys back.

Last time I had to do that, all of the connection strings were reset....

Can you maybe give the table structure, a few sample rows and your desired output please?

When you say registration, what exactly do you mean?

Blank sa password? That's rather dangerous.

Please don't cross post. It just wastes people's time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic592622-145-1.aspx

When specifying generic commands, angular brackets are used as placeholders, indicating that something needs to be put in their place, not that they need to be there. See the command...