I have had a bit of a disaster with our SQL server, and its temporarily
dead. I will reinstall from scratch but I have another SQL server on our
SBS server that I would like to use in the meantime. Can I import or
regsiter those files on the dead server into a database on the SBS sql
server?If you have all the files that constitutes the database (mdf, possibly ndf and ldf), you can try sp_attach_db.
Attach is only guaranteed to work if you cleanly detached the database first, however. It might work even if
you didn't. If it doesn't work, you need to do a restore from a backup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Child" <dawg@.alaskaSPAMFREE.com> wrote in message news:10ia37qkv0g41db@.corp.supernews.com...
> I have had a bit of a disaster with our SQL server, and its temporarily
> dead. I will reinstall from scratch but I have another SQL server on our
> SBS server that I would like to use in the meantime. Can I import or
> regsiter those files on the dead server into a database on the SBS sql
> server?
>
2012年2月14日星期二
Disable a subscription
Is there a way to temporarily disable a subscription and
re-enable it after I've whatever I need to do?
JoeYou can always change the dates when it occurs in the properties of of the
report. When you want it disabled, put a date very far in the future and put
the right date back when you want it to start again.
Cédric
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:82da01c477e3$11786180$a301280a@.phx.gbl...
> Is there a way to temporarily disable a subscription and
> re-enable it after I've whatever I need to do?
> Joe
>|||The short answer is no. The complex answer is sometimes. :) If the
subscription is a time based subscription based on a shared schedule, you
can pause the shared schedule. If it is on a scoped schedule you can set
the end date to a date already past. If the subscription is based on
snapshot execution then there is no way to disable the subscription.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:82da01c477e3$11786180$a301280a@.phx.gbl...
> Is there a way to temporarily disable a subscription and
> re-enable it after I've whatever I need to do?
> Joe
>
re-enable it after I've whatever I need to do?
JoeYou can always change the dates when it occurs in the properties of of the
report. When you want it disabled, put a date very far in the future and put
the right date back when you want it to start again.
Cédric
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:82da01c477e3$11786180$a301280a@.phx.gbl...
> Is there a way to temporarily disable a subscription and
> re-enable it after I've whatever I need to do?
> Joe
>|||The short answer is no. The complex answer is sometimes. :) If the
subscription is a time based subscription based on a shared schedule, you
can pause the shared schedule. If it is on a scoped schedule you can set
the end date to a date already past. If the subscription is based on
snapshot execution then there is no way to disable the subscription.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:82da01c477e3$11786180$a301280a@.phx.gbl...
> Is there a way to temporarily disable a subscription and
> re-enable it after I've whatever I need to do?
> Joe
>
订阅：
博文 (Atom)